Hi, I’m trying to automate a “status/priority” field based on “start/end date” fields - assigning one of the following options to every record:
I was able to create an IF-formula for 3 of the 4 options:
IF(Start <= TODAY(), IF(End >= TODAY(), “NOW”, “DONE”), “LATER”)
In the LATER group, I would now like to categorize the date closest to TODAY as NEXT but can’t seem to find a way to do this.
Any tips? Thanks!