Skip to main content
I am trying to use a picklist value in a conditional formula in an email template but I'm not have any success.

 

Here is the formula that just does not work...  I have tried both single and double quotes..

 

{!if(ISPICKVAL(UWI__c.Pre_Signed_Doc_Approved__c,'Approved with Change', "My test works","My test works")}

 

I used a regular text field and the formula (below) works fine.

{!if(UWI__c.Group_Number__c="", "Group Number Missing","Group Number There")}

 

 

Does anyone have any input on using a picklist in the conditional formula above? thanks!!!

 

 

Fred
3 answers
  1. Jul 23, 2012, 3:06 PM
    If you would like to apply the rule for single picklist value then you could use something like this:-

     

    {!if(ISPICKVAL(UWI__c.Pre_Signed_Doc_Approved__c,"Approved with Change"), "My test works","My test Fails")}

     

     
0/9000