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 want to add another line that will color code a checkbox field when it is check i.e. if "catering required" checkbox is checked, the event will be a different color. Having trouble making this work. I've tried ....[Food required?]="Yes" () "blue") for example. Do checkbox fields not work with the "Case" statement?
Case(true,[Date of Event]=Today(), "#2f9d66",
[Date of Event]<=Today(),"pink",
[Date of Event]>=Today(),"#ffffb3",)
This works well. I want to add another line that will color code a checkbox field when it is check i.e. if "catering required" checkbox is checked, the event will be a different color. Having trouble making this work. I've tried ....[Food required?]="Yes" () "blue") for example. Do checkbox fields not work with the "Case" statement?
