Change a Cell Automation on Dates
I am trying to run an automation that will change the priority cell based on the date in a date column.
See attached example.
I want the Priority Column to automatically change to 1. High if the Due to Copyedit Date is in the next 30 days (or past) and the Complete box is unchecked.
I want it to change to 2. Medium if it is in the next 60 days and box is unchecked.
And, I want it to change to 3. Low if it is more than 60 days away.
I haven't been successful with setting up these automations to all work simultaneously. Any ideas are appreciated.