You need to sign in to do that
Don't have an account?
Help with a formula!
I'm having trouble creating the correct syntex for a formula field. I have one piece working, which involves inserting a value if another multipick list field has a specific value selected.
(IF(INCLUDES(Account_Types__c , "Clinical"),"Clinical", " "))
But I also want to insert other values if other picklist options are selected. I tried adding an OR operator or OR function but just can't find the correct syntax. For example...
(IF(INCLUDES(Account_Types_c, "Clinical"),"Clinical"," ") OR (IF(INCLUDES(Account_Types__c , "Pharma/Biotech"),"Pharma/Biotech", " "))
Much thanks in advance!
Steve
IF(INCLUDES(Account_Types_c, "Clinical"), "Clinical", IF(INCLUDES(Account_Types__c , "Pharma/Biotech"), "Pharma/Biotech", ""))
Thanks.
All Answers
IF(INCLUDES(Account_Types_c, "Clinical"), "Clinical", IF(INCLUDES(Account_Types__c , "Pharma/Biotech"), "Pharma/Biotech", ""))
Thanks.
Steve