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
Ronald BrakeboerRonald Brakeboer 

Colour based on pickvalue (Error)

It has been asked before but for some reason I am missing some key elements.

Simple idea: When Case "Status"  (picklistvalue field) is like  "new" or "closed"  show some colour.
I wanted a simpe "IF Status contains "New" colour status field red. Well, that is not easily possible 

So I cam e up with "when Status equals "new" show red icon (which is an image)"
I tried this http://www.cloud113.com/salesforce-com-fun-with-colors/. I went into the Case> "Status" field and copied the code. but it gave me an error that "Image may not be used in this formula. Probably because it's a picklist value.  (Some code later, Error: Field Status is a picklist field. Picklist fields are only supported in certain function)

So I choose to make a new custom (rich text) field (Status_colour) that updates whenever  the status field changed and made a formula based on the custom field "Status_colour". That gave me an error that this field (Case_status_colour__c) cannot be used for the things I wanted or the error   Error: Incorrect parameter type for function 'TEXT()'. Expected Number, Date, DateTime, Picklist, received Text"

Does anyone holds the key?

 

 

 

 

 

 

Ronald BrakeboerRonald Brakeboer
Found the problem! For anone else: create a custom field, then pick formula as "type of information" (So not TEXT or whatever) and then choose OUTPUT type (THEN choose text)