Forum Discussion
MarkShnier__You
6 years agoQrew Legend
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
------------------------------
The formula is WeekDayAdd(Today(),1)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- IvanWeiss6 years agoQrew CaptainSo the problem is it is not always 1 day. That is just one example. It is all over the place in terms of "how many days"
------------------------------
Ivan Weiss
------------------------------- MarkShnier__You6 years agoQrew Legendvar number WeekDaysToAhead = ... some complicated formula goes here;
The formula is WeekDayAdd(Today(), $WeekDaysToAhead )
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- IvanWeiss6 years agoQrew CaptainNot sure I understand the "complicated formula".... I need to set this in the automation.... So how am I doing that in a formula?
------------------------------
Ivan Weiss
------------------------------