You need to sign in to do that
Don't have an account?
Terry_0101
Formula from multiple field values
Hello gentlemen
I have 3 account fields. If the values in all 3 meet a condition, then I want to checkbox a formula field. Will it look like this?
IF ( ISPICKVAL ( Type, "Customer" ), True,
IF ( AND ( ISPICKVAL ( Status__c , "New" ), True,
IF ( AND ( ISPICKVAL ( Source__c , "Webinar" ), True, False )))
I have 3 account fields. If the values in all 3 meet a condition, then I want to checkbox a formula field. Will it look like this?
IF ( ISPICKVAL ( Type, "Customer" ), True,
IF ( AND ( ISPICKVAL ( Status__c , "New" ), True,
IF ( AND ( ISPICKVAL ( Source__c , "Webinar" ), True, False )))
AND (ISPICKVAL ( Type, "Customer" ), ISPICKVAL ( Status__c , "New" ),
ISPICKVAL ( Source__c , "Webinar" ))
All Answers
NOT ( AND ( IF ( ISPICKVAL ( Type, "Customer" ),
IF ( ISPICKVAL ( Status__c , "New" ),
IF ( ISPICKVAL ( Source__c , "Webinar" ), True, False ),false),false)))
This will save values only when all values in the picklist will be as mentioned above.
This is not the optimum solution but it will work.
AND (ISPICKVAL ( Type, "Customer" ), ISPICKVAL ( Status__c , "New" ),
ISPICKVAL ( Source__c , "Webinar" ))