You need to sign in to do that
Don't have an account?
Kazjam
Traffic Light help required
Can anyone help advise me how to put an image into play. I have some custom fields that I want to show as traffic lights, however I have made these fields picklists with Green, Yellow and Red but I want them to be traffic lights and I'm not sure how I can use
the following formula to achieve this, can anyone give me some ideas, I'm clearly missing the point as I have two fields now one with a picklist and one with a traffic light.
IMAGE(
CASE( Project_Status__c,
"Green", "/img/samples/light_green.gif",
"Yellow", "/img/samples/light_yellow.gif",
"Red", "/img/samples/light_red.gif",
"/s.gif"),
"status color")
I use a status light in a formula like this:
Hi, thanks for you help, that's great, really useful.
:smileyhappy:
Regards, Kazjam