+ Start a Discussion
KazjamKazjam 

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")

pmozz01pmozz01

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")

KazjamKazjam

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

:smileyhappy:

 

Regards, Kazjam