Color coding based on Next Due Date field
I want to color rows that are past my Next Due date field Red. I get that to work. But then, I also want to color code anything that is 30 days or less out Yellow. I tried this....
If([Next Due ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendUnlike Excel you don't need to nest your IFs for most logic situations. Just list the conditions in the sequence you want them check d the first one wins.
If(
[Next Due Date]<Today()-Days(30), "Yellow",
[Next Due Date]<Today(),"RED"])
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
Thanks, Mark. I still can't get Yellow to work. Screenshots below. I feel like I am just overlooking something very simple here.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------