Skip to main content

Can someone help edit this formula?

  • October 17, 2024
  • 2 replies
  • 19 views
D
Forum|alt.badge.img+4

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:

The OG formula is too long to allow me to copy the entire thing in. This is the template: https://airtable.com/appcm1NtFWzs7vnnM/tblE0zWlg5lUgvbFU/viwOzsxF54gJeKpdS?blocks=hide
 
the formula is under the Next Due Date column
 
 
 
 
Can someone edit the formula to remove all of the options except for monthly reoccuring tasks? I don't need the 'Days (Only if Set to 1 Day(s))' column or any other recur units beyond Month(s). I've tried removing parts, but then the formula doesn't create the Next Due Date. 

 

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hmm, that link doesn't provide access to the formula I'm afraid

Adam, Airtable Consultant - thetimesaving.company
Alexey_Gusev
Forum|alt.badge.img+25

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})) ))
Terms & ConditionsAccessibility statement