+ Start a Discussion
jcookejcooke 

Formula question

What is the proper syntex for this IF statement? We want Salesforce Account type when it equals Inactive to display in Parature as type inactive. We have it set up correctly in our parature tool, but need to fix this one statement for it to work correctly. Any suggestions? 

 

IF(ISPICKVAL(Type,"Inactive"), ''inactive")

 

Thanks

Best Answer chosen by Admin (Salesforce Developers) 
shillyershillyer

You have a formula field you want updated based on the Account Type?

 

This should work:

 

 

IF(ISPICKVAL( Type , "Inactive"), "Inactive", "")

 

Hope that helps,

Sati

 

 

All Answers

shillyershillyer

You have a formula field you want updated based on the Account Type?

 

This should work:

 

 

IF(ISPICKVAL( Type , "Inactive"), "Inactive", "")

 

Hope that helps,

Sati

 

 

This was selected as the best answer
jcookejcooke

Thanks so much Sal

That worked!