Automation spanning multiple sheets
Current organization: within a single folder, there are about 10 sheets, each for a different project. The same Assignee will be present in multiple sheets.
I want an automation that will send a daily email to each Assignee listing all of their open tasks (i.e. start date has been met). I can do this for each individual sheet, but then the Assignee receives multiple emails when they are in multiple sheets. That's cumbersome; I want just one email.
I believe what I am needing is the ability to create an Automation at the Folder level (rather than sheet level).
Answers
-
You can only create automations at sheet level but you could have a two-step automation.
Step 1 in the individual sheets use the automation you have to copy the rows to another central sheet rather than send the alert.
Step 2 create the alert automation in the second sheet (where you will have all the rows to alert on). If you record a date as the final step in this automation, you can use that to ensure those rows are not included in subsequent emails.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives