Automation using reference cell
I hope you're doing well.
I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this monitoring is measured as the stages are marked as Complete. This calculation is straightforward with a formula that displays the result in the Percent column. However, the goal is for this value to appear in the % Complete column in the cell corresponding to the progress monitor. However, as this column is linked to the Project settings, it does not allow formulas.
I'm attempting an automation that would update this cell using the value from the percentage column, which would be kept hidden, only as an auxiliary. However, it seems not to be possible. Is there any way to do this?
I appreciate any help.
Help Article Resources
Check out the Formula Handbook template!