today() automatically change or not
Answers
-
Yes, a Copy Row automation that creates a new row in the destination sheet will update instances of TODAY() in formulas that are present in the destination sheet. This would be similar to adding a new row through a form.
As @Andrée Starå noted, if the TODAY formula is in the row being copied over, the formula won't be present as only the output text is copied over, not the underlying formula. However if there is a formula present in the destination sheet, such as in a top, summary row, or in an additional helper column, then these will update as new rows are added.
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Hi @Genevieve P I have tried but it seems not to work.
I generated an automation that copy every day at 2am a new row in the sheet where I have my master today(), but the cell in the row at the top of the sheet where today() is located doesn't get updated.
I am trying something different now, I have created a formula that contains a link to the cell where today() is located.
Every time a new row is added, the formula will be copied from the row above and will do a simple calculation using today() cell. Let's see if this make any difference.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!