Reminder Workflow
Hi there ;
İ would like to get your advices about below issue ;
I want to set a workflow that system will remind a row every 15 th of workday of each month.How can i set trigger on workflow for it ?
Thanks in advance for your kind replies
Erhan
Best Answer
-
I would suggest a helper column that contains the following:
=WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()), 1), 15)
This will output the date for the 15th working day of the current month. Then your automation would be set up to trigger based on this date column.
Answers
-
I would suggest a helper column that contains the following:
=WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()), 1), 15)
This will output the date for the 15th working day of the current month. Then your automation would be set up to trigger based on this date column.
-
thank you @Paul Newcome , it is working for me
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives