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.
Best Answer
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!