Mar 17, 2020 03:52 AM
This might be a bug.
On Gantt chart, I changed the End Date column to a formula (DATEADD) in order to insert the start date and the duration. It works fine in the table view.
But when I change the settings of the Gantt chart to use the formula column, the click and drag feature of the records in the chart is disabled, and I can only reschedule by typing into the record fields.
Mar 17, 2020 07:54 AM
Welcome to Airtable Community !
This is not a bug, thus is because you have a formula and therefore you cannot change the date since it will change the formula.
If you want to change the date with the drag option, change the field type to date.
Mar 17, 2020 09:31 AM
Thanks for the reply.
I understand, but for project/task management (a common use of Gantt charts) I find it much more easy to insert a start date and duration, instead of start and end dates.
It would be really helpful to at least have this as a choice.
Mar 17, 2020 07:43 PM
Yes I agree, I actually had the same problem and I contacted the support, thats why I knew the answer :slightly_smiling_face:
What I dis was the following:
I have a column for the start and duration and a formula. But i have a 4th row where I copied the result from the formula to, this is the end date i used in the Gantt. You can actually have a better shot at it now with the script block.
Jun 06, 2021 09:20 AM
What formula did youmuse to copy that end date and make it a date format?
Oct 05, 2022 02:48 AM
Hi! How was this solved? How can I make a copy of a date in a formula column and turn it into a date column to be able to include it as the end date in a Gantt view?
Oct 05, 2022 03:17 AM
For what you’re discussing here, you’d either have to use an automation or a script extension to handle it I believe
So you’d have:
End for Ganttfield
You’d then have the automation trigger whenever the
End field updates, and its action would be to paste the value of
End for Gantt
Same logic with a script extension, just that you’d trigger it via a button click instead