Usecase: I would like to update the background of an event based on a picklist value.
If the picklist values is any of these then :green else blue
Corp - Workday Rising US
Corp - Elevate US
Corp - Exec Programs
Corp - Tradeshows
I tried the formula for background color but this only show the first color:
if({{Campaign_Channel__c}} =
“Corp - Workday Rising US”, “#ff9b69”),
if({{Campaign_Channel__c}} =
“Corp - Elevate US”, “40a0ff”,“#217a37”)
What your code says is to use orange for Corp - Workday Rising US, blue for Corp - Elevate US, and green for anything else. The specs are not the same.
Is the formula in a UI-Only field in the model used as the Event Source on your calendar? Is that field used in the Background Color property on the Event Display tab for the Event Source?
Your code does have a syntax error as a ui-only field formula: the first close-parentheses, after ff9b69", should be at the end, after 217a37"). The format is:
if ( a, then,
if ( b, then, else )
)
The way I read your specs, you could code the formula as