You need to sign in to do that
Don't have an account?
Lisa Lee-Banks
Syntax for creating an image formula field
I need a red bar to appear when the following conditions are met on the record:
IF a checkbox value is true
OR
IF a date field is within 14 days of today AND a status field is a certain value.
This is what I have tried but the OR is giving me a syntax error.
IF(Checkbox = TRUE, IMAGE("/img/samples/color_red.gif ","red", 15,120),"blank")
OR(
IF( Date__c - TODAY() < 14,
IF(AND(ISPICKVAL( Status__c ,"Committed by client")),IMAGE("/img/samples/color_red.gif ","red", 15,120),"blank"))
IF a checkbox value is true
OR
IF a date field is within 14 days of today AND a status field is a certain value.
This is what I have tried but the OR is giving me a syntax error.
IF(Checkbox = TRUE, IMAGE("/img/samples/color_red.gif ","red", 15,120),"blank")
OR(
IF( Date__c - TODAY() < 14,
IF(AND(ISPICKVAL( Status__c ,"Committed by client")),IMAGE("/img/samples/color_red.gif ","red", 15,120),"blank"))
can you check now:
If you still face any issue then do let me know.
Regards,
Santosh Kumar
All Answers
Try below syntax,
Please mark as Best Answer if above information was helpful.
Thanks,
Santosh Kumar
can you check now:
If you still face any issue then do let me know.
Regards,
Santosh Kumar