AustinK
3 years agoQrew Commander
Re: Color-Coding Cells based on Dates AND Multi-Choice
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.
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.