Help

Re: Enter new deadline in recurring task?

1040 0
cancel
Showing results for 
Search instead for 
Did you mean: 
OpsDir_Cassie
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

I recently switched my team over to Airtable for project management. There were a few things holding me back, including that we'd have to build the automation for recurring tasks manually. 

Now that I have that built, I'm curious if I can get a formula into the automation which adds the proper deadline to the NEW task.

Issue is - there are different kinds of recurring tasks (Daily, weekly, monthly). Do I need to parse these out to create a separate automation for each of these types, and then enter a formula into the dynamic field type of the automation? (I'm also looking for the actual formula!) The other thing is if it is a daily task, we skip weekends, so we wouldn't want a new task to show a deadline of Saturday or Sunday. I'm not sure if this is possible 🙂 

Here's what the automation currently is: 

OpsDir_Cassie_0-1674582794730.png

I can add the deadline field, make it dynamic, have the previous deadline listed, and I think I'd need a formula that adds +1 day, +7 days, etc, correct? 

OpsDir_Cassie_1-1674582869695.png

 

 

6 Replies 6
augmented
10 - Mercury
10 - Mercury

First check out the WORKDAY function. It's like DATEADD, but only uses business days in the function. It also allows you to specify a list of holidays to incorporate as well. It breaks down a bit for the "monthly" requirement because of the 29/30/31 days of the month in our calendar. You can get close by specifying 22 or 23 days to add in the monthly condition. If this formula is not accurate enough, you might need to bring in more IF and WEEKDAY functions.  Here's an example using WORKDAY.

 

WORKDAY(Deadline,
  SWITCH(Freq,
    'Daily',1,
    'Weekly',5,
    'Monthly',22)
)
Jake_Wilson
6 - Interface Innovator
6 - Interface Innovator

I believe that I have what you're trying to accomplish implemented in a base of mine. 

Here's the base: https://airtable.com/shrnA67qyd57Pjg4l

This uses an automation which does not get copied over if you duplicate the base.  

We can hop on a call and I can help you get this finished up if you would like?  You can book a time on my calendar here

TheTimeSavingCo
17 - Neptune
17 - Neptune

Here's something I threw together.  You can duplicate the base to view the formulas and automation that it uses to run

Screen Recording 2023-01-25 at 4.13.41 PM.gif
I ended up doing `WEEKDAY` for tasks that are "Daily" and `DATEADD` for "Weekly" and "Monthly", so this won't be as accurate as augmented's suggestion

this is helpful, thanks.  I didn't realize that automations and interfaces got shared also when you make the base public

 

oh it looks like you can view the automations, but if you duplicate the base, it doesn't create them automatically

 

Hm that's weird.  When I duplicate the base the automation shows up in the duplicated base fully set up but not turned on.  But eh, as long as you're able to see the automation in the original base we should be good to go heh