Update Duration and automatically change dates

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?
Duration

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

2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.