Record a Date Automation

Hi!

Has anyone found a way to use Smartsheet automations to update a date filed a SPECIFIC date?

I want to find a way without building a helper sheet, or wasting space with helper columns, to record a specific archive date once a project is marked as "complete." I would like to archive all completed projects, regardless of when complete on the first day of our fiscal year.

In summary, if Project Status is "Complete" record "06/30/2025" in a date field, if false, then date field is blank.

Thanks!!!

Find more posts tagged with

Accepted answers

All comments

Mark.poole

@MWilkesen

You can’t record a date like that. How ever if you do an automation to change a cell instead you can make it be what ever you want.

jaimelynn0814FEB

Could you not create an automation to run once only on the first day of your fiscal year (say at 5pm) on 6/30/2025 (recurring annually), where condition project status = complete, record date 06/30/2025? I pasted a version of this in the image below using a sheet I have so obviously the fields aren't accurate, but would this not work for you?

MWilkesen

@jaimelynn0814FEB

O M G, I didn't even think about going that route!!

Great idea!

Thanks.

Michael

jaimelynn0814FEB

@MWilkesen so glad it may work for you! Happy to help. Sometimes (at least for me) I tend to over think things lol.

MWilkesen

I was definitely overthinking this one!!

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.