This should be simple and I hope it is.
I'm trying to get a date column to format in the following way:
If the date is GREATER than 2 weeks leading up to the date, its green
Is the date is LESS than 2 weeks until the date, its amber/yellow
If its past the date, its red.
However, if there is NO date input, it does nothing.
I've tried all I can with JSON, but it just alludes me. Any ideas? I can't seem to do it with the built in tools.