Forum Discussion

RachelMiller's avatar
RachelMiller
Qrew Cadet
9 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
AZAZ's avatar
AZAZ
Qrew Member
7 years ago
I created this and it worked for me. All you have to do is create a new TEXT Formula field. Put this formula it there. Change the field names to your fields and it should work. 

var text NameAbsenceHours = List(" | ", [Employee First Name] &" "& [Employee Last Name], [Absence],[Hours]);

If([Status]="Approved", "<b><font color = #008000>" & $NameAbsenceHours & "</font color></b>", "<b><font color = #FF0000>" & $NameAbsenceHours & "</font color></b>" )