Conditional Formatting to change status?
I'd like to be able to change the row status (planning/in progress/complete/overdue) depending on a required date in another column in that same row.
I have a report set up to report all overdue tasks and I'ld like to automate it more to change the status of all overdue tasks without any input from me.
Is this possible? I've explored the conditional formatting options but nothing seems to apply.