Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Update Duration and automatically change dates

Topic Labels: Views
1550 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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 2
8 - Airtable Astronomer
8 - Airtable Astronomer

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