Update Duration and automatically change dates

[Kendall_Shortt]

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?

[RnJ]

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

[Kamille_Parks]

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