Yesterday was one of those days that my brain failed me and I worked on what should be a rather simple formula for 4 hours (and it still didn't work)...
Object: Order
Field Referenced: Status
Field Options: Pending, In Process, Shipped, On Hold
Desired Outcome: Custom Field returns graphic traffic light based on status of order
I tried:
IMAGE(
CASE(
TEXT(Status__c),
"Pending", "/resource/1543431297000/yellowwarning",
"In Process", "/resource/1543431297000/yellowwarning",
"Shipped", "/resource/1543431181000/Green",
"On Hold", "/resource/1543431469000/RedHold",
),
""
)
I also tried:
IF(Status = "Pending", "resource/1543431297000/yellowwarning"),
IF(Status = "In Process", "resource/1543431297000/yellowwarning"),
IF(Status = "Shipped", "resource/1543431181000/Green")
I'm stuck :(
@Justin Gavette don't forget to show @Sunil Sarilla some love on his Profile page
Also nominations for new and renewal MVPs is now open =>
https://mvp-app-prod.herokuapp.com/campaigns/7011I000000N1Jr?&utm_source=salesforce&utm_medium=blog&utm_campaign=mvp_nominations