Automate Status based on Dates
I am looking for help with an IF formula to update the Status column based on 3 different dates:
Content Draft Date
Content Approval Date
Basically, I would like for the Status column to change to "In Progress" when the contact draft date is reached and remain as "In Progress" until Content Approval Date is reached, which will then change to "Approved" and remain as approved until the Delivery Date is reached, which it should then change to "Completed" and remain as "Completed".
Here is the formula I wrote:
=IF(AND([Content Draft Date]22 >= TODAY(), "In Progress", IF(AND([Content Approval Date]22 >= TODAY(), "Approved", IF(AND([Delivery Date]22 >= TODAY(), "Completed"))))))
Any help will be much appreciated!