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. 👍️