function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Gwen ONeill 9Gwen ONeill 9 

Formula to add Images

I'm trying to create a formula that will input specific colors/traffic lights, based on the date and how long it's been.  I tried the formula below but something must be off.  Could someone take a peek?

IF(TEXT( Last_Employee_Meeting__c) > ADDMONTHS( TODAY() , 6 ), IMAGE("/img/samples/light_red.gif"), 100,100)
IF (TEXT( Last_Employee_Meeting__c)  >= ADDMONTHS( TODAY() , 3 ), IMAGE("/img/samples/light_yellow.gif"),100,100)
IF (TEXT( Last_Employee_Meeting__c)   >= ADDMONTHS( TODAY() , 1 ), IMAGE("/img/samples/light_green.gif"),100,100)
NULL)))
VinayVinay (Salesforce Developers) 
Hi Gwen,

Hope you have stored images in documents and review below similar examples below that can help you.

https://help.salesforce.com/s/articleView?id=sf.useful_advanced_formulas_image_links.htm&type=5
https://trailhead.salesforce.com/de/trailblazer-community/feed/0D54S00000A7bAzSAJ

Please mark as Best Answer if above information was helpful.

Thanks,