Hi all, I am trying to understand how to use the column formatting (highlighting) for dates. My goal is the following:
Column Name: Internal Due Date
I would like the field to be green if the date is > today + 45 days
I would like the field to be yellow if the date is > today + 30 days, and
I would like the field to be red if the date is > today + 20 days.
It would be great if there was a statement that I could make for all of these in one, but I think that I may have to create a column for each color. I don't know. I can't locate an answer anywhere.
Can someone assist me with the best avenue to take to get this accomplished. Also, it seems like there might have to be a "between" in there somewhere.
Thanks for any help.
View best response