You need to sign in to do that
Don't have an account?
Gwen ONeill 9
Formula Logic to include an image
I am working on some custom fields to provide visualization of our clients' status. I need a little help with the formula below. The part referring to checkboxes (excellent, good, poor) are working. I'm trying to add in the option that if 2 fields are blank, it posts a different image. Thanks in advance for the help!
IF( Excellent__c = TRUE,IMAGE("/img/samples/color_green.gif", "green", 30, 30),
IF( Good__c = TRUE,IMAGE("/img/samples/color_yellow.gif","yellow", 30, 30),
IF( Poor__c = TRUE,IMAGE("/img/samples/color_red.gif", "red", 30, 30),""),
If(OR( ISBLANK( Last_Employee_Meeting__c), (ISBLANK(Last_Employer_Meeting__c)) )))((IMAGE("/img/samples/rating5.gif", "rating5", 20, 20))))))
IF( Excellent__c = TRUE,IMAGE("/img/samples/color_green.gif", "green", 30, 30),
IF( Good__c = TRUE,IMAGE("/img/samples/color_yellow.gif","yellow", 30, 30),
IF( Poor__c = TRUE,IMAGE("/img/samples/color_red.gif", "red", 30, 30),""),
If(OR( ISBLANK( Last_Employee_Meeting__c), (ISBLANK(Last_Employer_Meeting__c)) )))((IMAGE("/img/samples/rating5.gif", "rating5", 20, 20))))))
try with below formula.
if this helps, please mark it as best answer.
Thanks!!