Adding Overall % and Date Questions
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?
Best Answer
-
@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:
Answers
-
@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:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!