# Update a date field by users in one row and automatically update another rows date in task template table
**URL:** https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992
**Category:** Ask for Help
**Created:** [March 24, 2024, 2:27pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992 "2024-03-24T14:27:49Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 24, 2024, 2:27pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/1 "2024-03-24T14:27:49Z")
I have a task tamplate table that I want to automatically fill out other rows date field by defined formula. when an user input date in field in first row.
Input data is “Start Date” column drawn by red box in photo above
Thank you for help
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 24, 2024, 2:50pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/2 "2024-03-24T14:50:27Z")
You didn’t say what the formula is, but I’ll take a guess that you want to add the Duration Days value?
If that’s the case, do it as follows:
- Create a Single Value column that selects the first Start Date. This will apply the Start Date to every row in the table.
- Create a Math column using the following formula:
```auto
Start + Duration
```
- Replace Start with the Single Value column
- Replace Duration with the Duration Days column
---
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 24, 2024, 4:34pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/3 "2024-03-24T16:34:52Z")
Formula is:
**End Date** column=Start date+Duration days
**End Date+1** column=End date+1
My start date in first row will be user define and then
start date column value in 2nd~6th rows will be End Date+1 according to 1st row
---
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 24, 2024, 5:56pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/4 "2024-03-24T17:56:38Z")
that means strat date in each row will be:
2nd row start date\>\>\> 1st row **End Date+1**
3rd row start date\>\>\> 2nd row **End Date+1**
4th row start date\>\>\>3rd row **End Date+1**
5th row start date\>\>\>4th row **End Date+1**
6th row start date\>\>\>5th row **End Date+1**
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 25, 2024, 12:24am UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/5 "2024-03-25T00:24:19Z")
Will it always be 1 day for each task, and would you always create the order column? Do you do that manually?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 25, 2024, 2:29am UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/6 "2024-03-25T02:29:05Z")
Does the below look correct?
---
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 25, 2024, 11:51am UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/8 "2024-03-25T11:51:25Z")
it is near to correct.In your table rows 4 and 5 incorrect because these tasks are the same(please consider column “Dependencies” in my table)
in my table “ **Dependency End Date+1** ” column is lookup from " **New Colum A**" column relation
**Dependency End Date+1** value in row 2 will return to start date row 2 and etc.
you know actually I will use this table making for GANTT chart
---
### Author:  [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [March 25, 2024, 12:05pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/9 "2024-03-25T12:05:20Z")
> [@Kemal1973](#):
>
> I will use this table making for GANT chart
Have you ever tried using a calendar component instead of inputting the day (duration) to generate the date? In other words, you can very easily drag the start date and end date, then you just have to see the difference in days which is the result of the formula calculation. This is much simpler.
---
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 25, 2024, 12:22pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/10 "2024-03-25T12:22:21Z")
Actually , this table will be used to prepare a Gantt chart, and our input will be a date and the rest of the dates will correspond to the default duration
I want to enter a date manually then tasks start and end date be calculated correspond to the default duration
---
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 25, 2024, 12:39pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/11 "2024-03-25T12:39:39Z")
I think calendar component isn’t my solution.
I have a Task Template table that there are 20 project and each project has on average 20 tasks
---
### Author:  [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [March 25, 2024, 12:42pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/12 "2024-03-25T12:42:10Z")
It’s okay, I’m just sharing my experience. I also have a Gantt Chart table. I suspect you’ll move it to G Sheets.
I myself have switched to using the calendar component because:
1. Tasks that overlap in time are very easy to create. If you use your current method, time only progresses linearly without overlapping.
2. You can still maintain the fixed duration according to the default by dragging. In other words, you drag the bar, not changing the number.
3. Any changes in the middle row will not be automatically generated to the next row in your G Sheet; you only see it in the Glide table. With the calendar component, the person entering the data can easily check for anomalies/errors and adjust the dates below (like an agenda).
I mean, the use of the calendar is only as a tool for filling in dates, not for display, and it would be very powerful if combined with a data grid component. There are probably many more benefits that I haven’t mentioned.
---
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 25, 2024, 1:10pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/13 "2024-03-25T13:10:53Z")
Thank you for your attention and guidance
Your experiences were very helpful for me and I will definitely use them.
I had created this table by Airtable automation and it was working correctly but I was in Glide Free Plan.I have to upgrade to Maker Plan in Glide so Maker Plan doesn’t support Airtable 😞
---
### Author:  [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [March 25, 2024, 1:38pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/14 "2024-03-25T13:38:34Z")
Sorry if about Airtable I have never used it. After I check now the Team Plan minimum supports Airtable. I can’t comment on this.
---
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 25, 2024, 1:42pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/15 "2024-03-25T13:42:47Z")
Thanks but I have to use Maker Plan because of user number(unlimited user number)
---
### Author:  [@Kemal1973](https://community.glideapps.com/u/Kemal1973)
#### Post date: [March 25, 2024, 7:38pm UTC](https://community.glideapps.com/t/update-a-date-field-by-users-in-one-row-and-automatically-update-another-rows-date-in-task-template-table/71992/16 "2024-03-25T19:38:11Z")
Hi Darren,
could you explain about this table,I think it’s near the solution.