Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

Setup "Tomorrow" in automation as next work day

Hi an automation which creates a bunch of new tasks that are X days in the future....  It is assigning them on weekends.  How do I set the automation to only create tasks with a due date X work  days ...
Formulas and functions
Quickbase Automations
UserVoice
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You should be able to make a formula field to calculate the next work day and set the Automation to use that field. assuming that it is on the Trigger record.

The formula is WeekDayAdd(Today(),1)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------