I am trying to build the formula for a traffic light on an Account Field. The criteria is: If "Member Status" (this is a picklist field) = Active AND "Restriction" (this is a picklist field) Does NOT = Null, then display Yellow Light If "Member Status" (picklist) = Inactive, then display Red Light If "Member Status" (picklist) = Active AND "Restriction" (picklist) = Null, then display Green light.
This is what I have currently after changing multiple times according to syntex errors:
IF(
ISPICKVAL( Account_Status_New__c , "Inactive"),
IMAGE("/img/samples/light_red.gif", "red"),
IF(
AND(
(
ISPICKVAL ( Restriction_New__c <> " "),
(
ISPICKVAL( Account_Status_New__c , "Active")
)
),
IMAGE("/img/samples/light_yellow.gif", "yellow"),
IF(
ISPICKVAL( Account_Status_New__c , "Active"),
IMAGE("/img/samples/light_green.gif", "green" ),
null
)
)
)
I'm currently getting this syntax error:
Error: Syntax error. Missing ')'
but I'm not sure where to put as I've already added some and I think I might be making it worse.
Any suggestions are appreciated.
UPDATE: New formula and error:
Wondering what the appropriate syntax is for a blank picklist value