Nightly Automation with Today Formula
I seem to have a 'ghost' in my sheet where only half of my automated workflow seems to work on any given day.
My sheet (called a playbook) has half of the rows with =Today() date formula, and the other half with a hard-coded date; each night at 11:00pm PST my worflow copies the Today rows to a 2nd sheet (called a tracker) and then moves any other date to the same tracker.
In the tracker, the rows sit until 12:00AM PST and then rows 1 day in the past move back to the playbook.
This is a daily automation, and once a week the 'ghost' pops in where rows in the tracker (1 day in the past) are not making it back into the playbook and the today formula is lost.
Now I have the same exact workflow and logic built into 3 playbooks, and this ghost pops up once a week on any given sheet and any given day.
Help!
Answers
-
Hi Nichole,
I too face the same issue, based on my finding the date format and server date are mismatching and causing issues. It also depends on the region where you are located.
Try the smartsheet date setting what you have and the format in the sheet cell range. keep observing for a day and I hope you should be able to find the GAP to fix it.
Let me know!
Thanks,
Don.
-
Thanks @boscod35 - my sheets are created on the PST however is accessed nationwide. We have asked users to stay out during the 2 hour period for archiving or copy/move rows.
Luckily this week we had no errors but maybe the ghost is hibernating - fingers crossed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!