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

Find more posts tagged with

Accepted answers

Paul Newcome

Try something like this...

IF(TODAY() >= [Delivery Date]@row, "Completed", IF(TODAY() >= [Content Approval Date]@row, "Approved", "In Progress"))

All comments

Paul Newcome

Try something like this...

IF(TODAY() >= [Delivery Date]@row, "Completed", IF(TODAY() >= [Content Approval Date]@row, "Approved", "In Progress"))

Vanessa Campos

Thank you Paul, this is very helpful!!!

Paul Newcome

Happy to help! 👍️

Scott Nuss

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.

Paul Newcome

@Scott Nuss What are your exact requirements?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.