Forum Discussion

FionaCarr's avatar
FionaCarr
Qrew Trainee
6 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
6 years ago
Thanks. It would work, except I realise I'm asking it to conflicting things i.e. any event is going to be (past, today, or future) AND might have food. So it can't handle two conditions on one event correct?