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!
Thanks
Best Answer
-
Try something like this...
IF(TODAY() >= [Delivery Date]@row, "Completed", IF(TODAY() >= [Content Approval Date]@row, "Approved", "In Progress"))
Answers
-
Try something like this...
IF(TODAY() >= [Delivery Date]@row, "Completed", IF(TODAY() >= [Content Approval Date]@row, "Approved", "In Progress"))
-
Thank you Paul, this is very helpful!!!
-
Happy to help! 👍️
-
Hello, I am trying the same but with Not Started, In Progress and Complete based on my dates. I am having trouble as this is my first formula writing in Smartsheets. Any help would be appreciated. Thank you.
-
@Scott Nuss What are your exact requirements?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!