Triggering when Start date Reached or Between Start Date & End Date Entered
Answers
-
Do you need 2 sheets or could you report on sheet 1 between the dates?
If you need two sheets, maybe you could use the Modified Date and a helper column to tick if the modified date is between the Start and End date. Then if the helper column is set to 1 (ie it ticks) then this could be the trigger for the copy row automation?
I'd be happy to explain further if you'd like to reach out to me.
Kind regards
Debbie
-
Hi Debbie,
Many thanks for responding. Your suggestion with the modified date is a great idea . I would like to reach out to you for further explanation. Thanks in advance.
-
Sure @Vinton Douglas
My email address is debbie.sawyer@smarterbusinessprocesses.com - pop me an email and I'll set up a zoom to chat some ideas through with you.
Kind regards
Debbie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!