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"])
Thanks, Mark. I still can't get Yellow to work. Screenshots below. I feel like I am just overlooking something very simple here.
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:
[Next Due Date]<(Today()+Days(30)), "Yellow",
LOL. As I said, I was overlooking something simple. 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. Thanks for pointing it out, folks. Your help for the newbie is greatly appreciated. (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.)
