Help with a formula to auto change the status column.
Hoping someone can help me with a formula, if its possible.
I'd like a formula to change the status to "Upcoming" if the date is 30 days in the future of the start date and completed date is blank, and update to "overdue" if target date is 1 day past, and completed date is blank.
Help Article Resources
Check out the Formula Handbook template!