Discussions

Expand all | Collapse all

Color coding calendar report for a checkbox field

  • 1.  Color coding calendar report for a checkbox field

    Posted 09-13-2018 15:39
    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?


  • 2.  RE: Color coding calendar report for a checkbox field

    Posted 09-13-2018 16:29
    try this

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



  • 3.  RE: Color coding calendar report for a checkbox field

    Posted 09-13-2018 17:07
    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?



  • 4.  RE: Color coding calendar report for a checkbox field

    Posted 09-13-2018 17:09
    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.