Oct 17, 2024 10:56 AM - edited Oct 17, 2024 12:04 PM
Hi! Below you'll find two screenshots - one is the template I started with and the other is the base I'd like to implement the reoccuring tasks formula/automation:
Oct 17, 2024 06:21 PM
Hmm, that link doesn't provide access to the formula I'm afraid
Oct 19, 2024 03:14 PM
Hi,
You can use this formula for past Due Dates, it uses any Recur Interval and Unit except it Ignored weekdays column. But I don't quite sure how it supposed to work with future Due Dates (I need example of input/output to do it), so you can improve it, if needed.
IF({Recur Interval},DATEADD({Due Date},
{Recur Interval}*ROUNDUP((1+DATETIME_DIFF(TODAY(),{Due Date},
LEFT({Recur Unit},-1+FIND('(',{Recur Unit}))))/{Recur Interval},0),
LEFT({Recur Unit},-1+FIND('(',{Recur Unit})) ))