1. I created a new opportunity picklist field called "Status" with picklist values "Red, Yellow, Green"
2. I added the following formula to the "Status" field and get the following error
How do I fix this?
Thanks!
4 answers
David, you cannot write a formula like that in the field definition itself . What you instead need to do is create a new custom formula field as explained below:
- Data Type: Formula
- Return Type: Text
- Formula:
IMAGE(
CASE(
Status__c,
"Green", "/img/samples/light_green.gif",
"Yellow", "/img/samples/light_yellow.gif",
"Red", "/img/samples/light_red.gif",
"/s.gif"),
"Status color"
)
Now add this field to the Report and you should get what you need.
That's it!
