How to generate dates faster through automated workflows?
I have a sheet that sends automatic update requests once a new row is added. Once a new row is added through a form, the creation date is automatically generated to the current date and also a follow-up date is generated automatically at the creation of the new row.
However, the dates do not generate quickly enough and so when an update request is sent by email with all the information of the new row (including the creation date and follow-up date), those fields appear blank in the email. It takes a few minutes for the dates to appear in the sheet, but it's too late for the update request.
So
1) a form is completed which creates a new row
2) the sheet is updated (NOT the dates yet…)
3) The update request is sent with all the info in the new row but dates dont appear in it.
What can i do for the dates to generate faster so they appear in the update request email?
Answers
-
You can adjust your trigger to account for all pieces of data being populated.
-
What @Paul Newcome said - more specifically, for example, you could have the update request automation get triggered by the Follow-up date changing to a value, if that only gets changed by the row creation automation and never changes after that initial automation when a row is added.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 413 Global Discussions
- 221 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives