Skip to main content
Question

Color coding calendar report for a checkbox field

  • September 13, 2018
  • 0 replies
  • 90 views
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?
    This topic has been closed for replies.

    try this

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

    • FionaCarr
    • Author
    • Quickbase Alumni
    • September 13, 2018
    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?

    • FionaCarr
    • Author
    • Quickbase Alumni
    • September 13, 2018
    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.
    Terms & ConditionsAccessibility statement