I had an image formula field running off a picklist that had fixed values 1,2,3,4,5. The formula worked and showed a red, amber, green, light blue, or dark blue image respectively. To make the picklist more meaningful, I changed the numbers to words. My Image formula stopped working. I tried with and without ISPICKVAL(), TEXT() and nothing before Support_level__c. Nothing happening.
IMAGE(
CASE( ISPICKVAL(Support_Level__c ,
"Intensive Support", "/servlet/servlet.FileDownload?file=0150g000002vla0",
"Middle Range Support", "/servlet/servlet.FileDownload?file=0150g000002vla5",
"Some Support and Stable", "/servlet/servlet.FileDownload?file=0150g000002vlaF",
"Little Support and Stable", "/servlet/servlet.FileDownload?file=0150g000002vlaA",
"Ready to move on", "/servlet/servlet.FileDownload?file=0150g000002vlaA",
"Undefined")),
"Undefined")
I then tried a work around! Lightbulb. I created a number field which was updated by a workflow according to what the Support_Level__c values was.
IMAGE(
CASE(Update_Traffic_Number__c,
1, "/servlet/servlet.FileDownload?file=0150g000002vla0",
2, "/servlet/servlet.FileDownload?file=0150g000002vla5",
3, "/servlet/servlet.FileDownload?file=0150g000002vlaF",
4, "/servlet/servlet.FileDownload?file=0150g000002vlaA",
5, "/servlet/servlet.FileDownload?file=0150g000002vlaA",
"Undefined")),
"Undefined")
Still no joy. The number field was not updating so I could not test this formula. I made number formula field to see if that would help. Nope. It did not update. There is something in the Support_Level__C field that I am not translating through anymore.
The other versions I have played with (using the traffic light formula field):
CASE( Traffic_Light_No__c ,
1, IMAGE("/servlet/servlet.FileDownload?file=0150g000002vla0","Red"),
2, IMAGE("/servlet/servlet.FileDownload?file=0150g000002vla5", "Amber"),
3, IMAGE("/servlet/servlet.FileDownload?file=0150g000002vlaF", "Green"),
4, IMAGE("/servlet/servlet.FileDownload?file=0150g000002vlaA", "Light Blue"),
5, IMAGE("/servlet/servlet.FileDownload?file=0150g000002vlaA", "Dark Blue"),
"Undefined")
And this:
IF( (ISPICKVAL(Support_Level__c, "Intensive Support")), (IMAGE("/servlet/servlet.FileDownload?file=0150g000002vla0", "Red")),
IF( (ISPICKVAL(Support_Level__c, "Middle Range Support")), IMAGE("/servlet/servlet.FileDownload?file=0150g000002vla5", "Amber"),
IF( (ISPICKVAL(Support_Level__c, "Some Support and Stable")), IMAGE("/servlet/servlet.FileDownload?file=0150g000002vlaF", "Green"),
IF( (ISPICKVAL(Support_Level__c, "Little Support and Stable")), IMAGE("/servlet/servlet.FileDownload?file=0150g000002vlaA", "Light Blue"),
IF( (ISPICKVAL(Support_Level__c, "Ready to move on")), IMAGE("/servlet/servlet.FileDownload?file=0150g000002vlaA", "Dark Blue"),
"Undefined")))))
I think I have now been looking at this so long I can't see my way!