Today() Update when rows added through Automation

The documentation for the Today() Function lists the conditions under which a formula using Today() will and will not update to the current date.

TODAY Function | Smartsheet Learning Center

There is no mention of what happens when rows are added to a sheet from another sheet via a MOVE or COPY automation. It does say that if rows are added via a FORM SUBMISSION, the Today() function updates. I would assume a similar behavior - but I need confirmation.

Also worth noting is that my formula is a Sheet Summary Formula. No mention in the documentation if that alters behavior.

Does anyone know definitively what behavior to expect?

I am aware of the workaround that uses a "Today Helper" column coupled with daily automation to populate it. I am trying to avoid using that because my formula also evaluates the Created Date and Modified Date. I don't want to update every row each day because that action contaminates the Modified Date.

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @SJ Sellers

I can confirm that a Move Row or a Copy Row workflow that adds a new row to your source sheet will update the Today Function in that sheet, including if that function is in a formula in a Sheet Summary field.

Thank you for your feedback around the Help Article - I will pass this along to our Content team!

Cheers,

Genevieve

All comments

Genevieve P.

Hi @SJ Sellers

Thank you for your feedback around the Help Article - I will pass this along to our Content team!

Cheers,

Genevieve

SJ Sellers

Hi @Genevieve P. -

Thank you for your response!! I created a little test just to be sure and in the test, it is working as I had hoped. I appreciate you confirming here as well!!

Best, SJ

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.