Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Trainee
3 years ago

Color-Coding Cells based on Dates AND Multi-Choice

I have a multi-choice field that you can do one of three things with. 1) Leave it blank 2) Select "Missed" 3) Select "Scheduled" I want the field next to it to color-code base on the info.  1) If...
Formulas and functions
AustinK's avatar
AustinK
Qrew Commander
3 years ago
Your formula works from the top down. Once it finds the first thing in that formula that matches it ignores the rest of it. 

If(
[Scheduled - Yes] = "Scheduled" ,$green,
[Scheduled - Yes] = "Missed" ,$gray,
[Scheduled - Yes] = "" and [Appointment Needed By] >= Today(),$yellow,
[Scheduled - Yes] = "" and [Appointment Needed By] < Today(),$red
)

This would color anything with Scheduled selected green, ignoring any other thing on the record. Gray if Missed is selected, and then if blank would color either yellow or red. Let me know if it does not work as anticipated but I think it should. 

Although now that I look at your post you have given your old formula so this may not help you at all since you are asking how to update a new formula that is not here.
  • MeaganMcOlin's avatar
    MeaganMcOlin
    Qrew Trainee
    3 years ago

    Austin,

    Basically, I'd like to know how to update the below code - it is written for a checkbox field type, but need it to work for a multi-choice field type instead (where the multi-choice options are Missed & Scheduled). 

    If([Scheduled - Yes]=true,$green,

    If([Scheduled - Yes]=false and [Appointment Needed By]  >= Today(),$yellow,

    If([Scheduled - Yes]=false and [Appointment Needed By] < Today(),$red)))

    Thanks!



    ------------------------------
    Meagan McOlin
    ------------------------------