Forum Discussion

FionaCarr's avatar
FionaCarr
Qrew Trainee
7 years ago

Color coding calendar report for a checkbox field

I have a calendar report that uses the following formula: Case(true,[Date of Event]=Today(), "#2f9d66", [Date of Event]<=Today(),"pink", [Date of Event]>=Today(),"#ffffb3",) This works well. I w...
App builders
Formulas and functions
FionaCarr's avatar
FionaCarr
Qrew Trainee
7 years ago
I took out the "future" event color coding and so just future events show blue if they require food (or else they are grey). That works. Thank you.