Automate Status based on Dates


Hello Everyone,

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

Delivery 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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!