Adding Overall % and Date Questions

Lizk2

I am using the Project Manager Office Template from Smartsheet. I would like to have the very top row (it is almost like a summary row), calculate the overall % complete of the project and adjust the start and end dates as the schedule changes/ progresses. I tried adding a formula to both sections but it would not actually apply to the cells. Any insight?

Razetto

@Lizk2 The template should be already setup so that the top row, ancestor or parent row, changes as changes are made in the indented rows, children; but your screen shot doesn't show the primary column to tell how it's setup. I would also look into the dependencies under the Project Settings as there are multiple date columns

More on project rollup and tracking:

https://app.smartsheet.com/b/publish?EQBCT=516ae416f42542db8996111e1bab2273&_ga=2.165954041.670723227.1687788854-1722716970.1628006326&_gl=1*1fnl037*_ga*MTcyMjcxNjk3MC4xNjI4MDA2MzI2*_ga_ZYH7XNXMZK*MTY4Nzk2MDg0My4xOTkuMS4xNjg3OTYxNjc4LjQ2LjAuMA..

Razetto

@Lizk2 The template should be already setup so that the top row, ancestor or parent row, changes as changes are made in the indented rows, children; but your screen shot doesn't show the primary column to tell how it's setup. I would also look into the dependencies under the Project Settings as there are multiple date columns

More on project rollup and tracking:

https://app.smartsheet.com/b/publish?EQBCT=516ae416f42542db8996111e1bab2273&_ga=2.165954041.670723227.1687788854-1722716970.1628006326&_gl=1*1fnl037*_ga*MTcyMjcxNjk3MC4xNjI4MDA2MzI2*_ga_ZYH7XNXMZK*MTY4Nzk2MDg0My4xOTkuMS4xNjg3OTYxNjc4LjQ2LjAuMA..