You need to sign in to do that
Don't have an account?
CRMsimple
Image Formula Field for colored flags - Need Help!
I got this to work fine
IMAGE (IF( Days_Open__c < 4,"/img/samples/flag_green.gif", "/img/samples/flag_red.gif"),
"Status Flag")
But now I want to add more statements like Days_Open_c > 4, but < 7 yellow, or >= 7 red
Can anyone help me with this?
IMAGE (IF( Days_Open__c < 4,"/img/samples/flag_green.gif", "/img/samples/flag_red.gif"),
"Status Flag")
But now I want to add more statements like Days_Open_c > 4, but < 7 yellow, or >= 7 red
Can anyone help me with this?
"Status Flag" )
Something like that. I don't think you can use Case here, even though you are relying on the same field. Looking forward to some corrections from others on this board.
All Answers
"Status Flag" )
Something like that. I don't think you can use Case here, even though you are relying on the same field. Looking forward to some corrections from others on this board.
You can avoid nested IFs by using CASE.
For more information see the examples:
http://login.salesforce.com/help/doc/en/useful_advanced_formulas.htm#CaseManagementTitle