Hello all,
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:
IF({Numbers} = 1, SUBTRACT_DAYS({Date}, 60), IF({Numbers} = 2, SUBTRACT_DAYS({Date}, 55), … {Date})
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.
Thank you!