I am trying to integrate an automatic timeline into a project board. We currently use Google Sheets to figure out timing for all tasks associated with the project and it calculates all timing ratios once a date is entered.
I was able to complete this first step by assigning each task a number with the numbers column, creating a date column with deadline, and using the formula column with the following:
Now I am wondering if there is a way for the formula column to use the date calculated and transfer to the timeline column automatically? Or is this a feature that is not currently available? I am also open to feedback if this could be streamlined.
Hi @vcruz1 - If you’re open to using apps, I wanted to share a quick tip. If you can copy your calculated date into a standard Date column (manually or through an automation), our app Smart Timeline + Duration can take it from there. It lets you automatically create or update a Timeline column based on that date.
We built it specifically for advanced scheduling workflows like yours, and it comes with 20+ automation recipes you can explore and tailor to your workflow.