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.
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.
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.
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