Automate sheet export to excel on workday 6
MAshfield
✭✭
Hi,
I am trying to automate the scheduled send of a sheet on the 6th workday of every month.
I have explored two options:
- File --> send as attachment. Issue is that the 'send monthly' only allows you to select workdays 1-4, or the last workday of the month.
- Automation for 'alert when a date is reached' and work out formulas for the necessary date. Problem is that there is no auto-export notification through the manage workflows tab.
Does anyone have any advice on how to achieve this aim? Any help would be greatly appreciated!
Answers
-
@MAshfield Use Send Monthly on Day 6
-
Thanks Paul, although I assumed this would be the 6th day instead of specifically the 6th working day of the month?
-
Sorry I missed the workday part.
Yes you are correct that would be every 6th of the month, not every 6th workday.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives