Color coding based on Next Due Date field

Question

I want to color rows that are past my Next Due date field Red.&nbsp; I get that to work.&nbsp; But then, I also want to color code anything that is 30 days or less out Yellow.&nbsp; I tried this....
If([Next Due Date]&lt;Today(),"RED")If([Next Due Date]&lt;Today()-Days(30), "Yellow")

It not only doesn't do red anymore, after working as a single line, but it also won't color yellow.
------------------------------Gonzo -  A Newbie, but learning fast.  (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------

markshnier__you · Answer

Unlike Excel you don't need to nest your IFs for most logic situations. &nbsp;Just list the conditions in the sequence you want them check d the first one wins.

If(
[Next Due Date]&lt;Today()-Days(30), "Yellow",
[Next Due Date]&lt;Today(),"RED"])------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

tonygonzalez · Answer

Thanks, Mark.&nbsp; I still can't get Yellow to work.&nbsp; Screenshots below.&nbsp; I feel like I am just overlooking something very simple here.&nbsp;&nbsp;------------------------------Gonzo -  A Newbie, but learning fast.  (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------

chayceduncan · Answer

Are you expecting the first row to be yellow? If yes - looks like you might have the 30 days evaluation backward. Sine the next due date of that row is 2/10/24 then I imagine you want it yellow if it's in the next 30 days in which case your row for that condition would be:&nbsp;
[Next Due Date]&lt;(Today()+Days(30)), "Yellow",------------------------------Chayce Duncan------------------------------

tonygonzalez · Answer

LOL.&nbsp; As I said, I was overlooking something simple.&nbsp; Once I quit trying to do this with either a UNC basketball game in the background or on a Zoom call, I actually saw the mistake.&nbsp; Thanks for pointing it out, folks.&nbsp; Your help for the newbie is greatly appreciated.&nbsp; (It should be noted the above mentioned Zoom call was with my QB rep working out what kind of quote what we needed, so at least it was all QB related. Oh, and UNC won last night as well.)------------------------------Gonzo -  A Newbie, but learning fast.  (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------

Forum Discussion

Color coding based on Next Due Date field