Help

create automation to auto update workback schedule

505 0
cancel
Showing results for 
Search instead for 
Did you mean: 
meg1
4 - Data Explorer
4 - Data Explorer

Hello! I have an event workback schedule set up with a formula column to auto-generate a due date based on what date I specify in my date column (see ex. formula below). However, I would like to have the formula column auto-generate a list of due dates based on one 'master' date. I BELIEVE this would be an automation, possibly?

For example, we have an event coming up on April 7th. I would like to specify 'April 7th' in Airtable and have all the due dates in my work back schedule auto-update. Rather than go through each row and change the date. 

 

DATETIME_FORMAT((SWITCH(
  {Deliverable},
  "Request agenda items", DATEADD({Meeting Date}, "-10", "days")
0 Replies 0