+ Start a Discussion

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.


CASE( Project_Status__c,

"Green", "/img/samples/light_green.gif",

"Yellow", "/img/samples/light_yellow.gif",

"Red", "/img/samples/light_red.gif",


"status color")


I use a status light in a formula like this:


Data TypeFormula  
IMAGE( CASE( Opportunity_Status__c , "On Track", "/img/samples/light_green.gif", "On Hold - Customer", "/img/samples/light_yellow.gif", "On Hold - DuPont", "/img/samples/light_yellow.gif", "Behind Schedule-Due to Others", "/img/samples/light_red.gif", "Behind Schedule-Sales Pro", "/img/samples/light_red.gif", "/s.gif"), "status color")


Hi, thanks for you help, that's great, really useful.



Regards, Kazjam