Color coding calendar report for a checkbox field

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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?
Photo of fiona carr

fiona carr

  • 162 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
try this

IF(
[Date of Event]=Today(), "#2f9d66",
[Date of Event]<=Today(),"pink",
[Date of Event]>=Today(),"#ffffb3",
[Food required?]=true,  "blue")

Photo of fiona carr

fiona carr

  • 162 Points 100 badge 2x thumb
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?

Photo of fiona carr

fiona carr

  • 162 Points 100 badge 2x thumb
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.