How do I automatically add today's date when something is marked "complete" in status?

I have been using the formula =IF(Status@row = "complete", TODAY()) to add the date into a "completion date" column.

I thought that it was working, but it updates the date every time I open the Smartsheet. I wanted it to just give the date when it was marked "complete" and then keep that date. Is that possible?

Find more posts tagged with

Accepted answers

sravya.gupta127326

You can use the new Record Date automation for this - it works beautifully. https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.55574114.839407798.1617699064-1916390700.1572860636

All comments

sravya.gupta127326

Sabrina Petersen

That is exactly what I needed. Completely forgot about automation. 🤦‍♀️

MGarrison

This doesn't work for the example provided. Record Date will not write into the End Date column. It seems like a helper column is required for actual end date which can then be referenced in a formula, overcomplicating something that should be easy.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.