Skip to main content

Update Duration and automatically change dates

  • October 2, 2020
  • 2 replies
  • 38 views

Hey everyone,

I am trying to add our product managers into Airtable and they would like to have a project schedule with the Gantt chart that also has dependents on the previous steps.

My issue is they want to change the duration column from 10 to 8 for instance and the dates would automatically change. I’m assuming the start date is set but the end date is what needs to be updated.

Any tips on how to make this happen?

2 replies

Forum|alt.badge.img+14
  • Inspiring
  • October 2, 2020

Make end time formula field and start date include hours, then try this - DATEADD({Start Date},Duration,‘hours’)


Kamille_Parks11
Forum|alt.badge.img+27

Make end time formula field and start date include hours, then try this - DATEADD({Start Date},Duration,‘hours’)


I’m pretty sure they want to add days, not hours:
DATEADD({Start Date},Duration,'days')