+ Start a Discussion
Terry_0101Terry_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 )))
Best Answer chosen by Terry_0101
BalajiRanganathanBalajiRanganathan
it should be simple like this

AND (ISPICKVAL ( Type, "Customer" ), ISPICKVAL ( Status__c , "New" ),
ISPICKVAL ( Source__c , "Webinar" ))
 

All Answers

Deepak Sharma 12Deepak Sharma 12
Hi Samantha_

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.
BalajiRanganathanBalajiRanganathan
it should be simple like this

AND (ISPICKVAL ( Type, "Customer" ), ISPICKVAL ( Status__c , "New" ),
ISPICKVAL ( Source__c , "Webinar" ))
 
This was selected as the best answer