Skip to main content

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 :(

4 comentarios
0/9000