You need to sign in to do that
Don't have an account?
Kazjam
Formula help need please for an image
Hi, I am having trouble with a formula that I have created, one part works which is the light turns to red when the value is less than 40% but for the 2nd part of the formula I can't get the green, when it is more than 40% - here is the formula I have created, any help that anyone can give is great. I am a new user to salesforce and appreciate any assistance given. The syntax compiles with no errors. I have tried putting in a >40 but it
doesn't like the great than, I have also tried >=40 but it doesn't like that either, I believe this formula should change to green if it is not less than 40% am I missing something?
IMAGE (IF( Actual_Margin__c < 40,"/img/samples/light_red.gif", "/img/samples/light_green.gif"),
"status color")
"status color")
IMAGE (IF( Actual_Margin__c < 0.40,"/img/samples/light_red.gif", "/img/samples/light_green.gif"),
"status color")
Give that a try and see if it makes any difference.
I have a similar scenario where I would like to flag the close date field if it is not in compliance with our sales cycle, i.e stage 8 has a sales cycle of 8 months, but the close date is set to close in 1 month. I'm not sure exactly where or how I do this. Any advice would be greatly appreciated.
Thanks,
Kim