Help

Re: Can someone help edit this formula?

187 0
cancel
Showing results for 
Search instead for 
Did you mean: 
dkals
4 - Data Explorer
4 - Data Explorer

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
 
Screenshot 2024-10-17 at 1.54.42 PM.png
 
Screenshot 2024-10-17 at 1.47.24 PM.png
 
 
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 2

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

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})) ))