Forum Discussion

RachelMiller's avatar
RachelMiller
Qrew Cadet
11 years ago

How do I add color coding to a calendar report based on text?

I have a calendar report that I need to add color coding to. I'm looking for a simple formula that says: If [Activity] = Build, make bar green If [Activity] = Go-Live, make bar red If [Activity] ...
Formulas and functions
reports and charts
Tables and fields
ArchiveUser's avatar
ArchiveUser
Qrew Captain
10 years ago
You might try using a formula field called "Activity Color":

If(

[Activity]="Build","#00FF00",

[Activity]="Go-Live","#FFC0CB",

[Activity]="Support","#00FFFF"

)

Next, make a formula field called "Activity Label":

"<div style=\"background-color:" & [Activity Color]  &";\">" & [Activity] &"</div>"


Now you can use the "Activity Label":as the display option in your calendar.