I currently use a Formula column to automatically calculate a timeline based on two inputs:
-Deadline
-Duration (number of days)
The formula correctly generates the timeline, but since Formula columns are not supported in Gantt view, I still need to manually copy the dates into a regular Timeline column. This defeats the purpose of automation and creates extra manual work.
I tried using Automations and Workflows, but neither currently supports:
-Setting or updating values in a Timeline column, or
-Directly calculating a timeline from Duration + Deadline without using a Formula column.
It would be extremely helpful if monday.com could add one of the following:
1-Allow Workflows/Automations to set values in a Timeline column, OR
2-Add native support for generating a Timeline directly from Duration + Deadline, OR
3-Allow Formula column outputs to sync or mirror into a Timeline column so the values can be used in the Gantt chart.
Thank you!
What are you trying to achieve
Feature Request: Automate Timeline Column Based on Duration + Deadline (or Sync Formula → Timeline)
The good news is that you can achieve this using Workflows.
A common approach is:
• Create two Formula columns - one calculating the Start Date and one calculating the End Date
• Then use a Workflow to take those two formula outputs and automatically populate your Timeline column
This way, your Timeline stays updated automatically and works perfectly with the Gantt view - no manual copying needed
I’ve attached a screenshot of the workflow setup I’m referencing above.
Make watches your board for changes to the Deadline or Duration columns.
When either value is set or updated, Make calculates the correct start date based on the Deadline and Duration.
Make then automatically updates the Timeline column with the calculated start and end dates.
This removes the need to use a Formula column or manually copy values. Your Timeline column will be filled automatically, and the dates will work properly in Gantt view.
This approach keeps everything fully automated and ensures your timeline always stays accurate.
