Function
Hello, can someone tell me who to write the function to calculate the numbers in each of the highlighted cells?
Answers
-
Hi @ejacksonBPT
There are a few ways to go about this. The most straightforward way is to use =AVG([% Complete]<insert row numbers>).
If you are using a Project Sheet (started by clicking on the gear in the top right and designating columns in the Dependency settings), you can use the hierarchy in your WBS to give you a rough idea. The parent tasks won't inherent any % until all the child tasks are at 100% which can be confusing for getting an idea of progress/baselining.
Using the AVG formula can end up being a headache as WBS/Task lists get larger and more complex because you need to ensure that the formula is catching every task. I have an example below showing the differences, with the % Complete being from the Dependency Settings, and the % Complete AVG using:=AVG([% Complete AVG]2:[% Complete AVG]6) - Yellow
=AVG([% Complete AVG]8) - Purple
=AVG([% Complete AVG]1, [% Complete AVG]7) - Orange
Let me know if you have any questions or would like me to elaborate on anything!
-
Is there a way to divide the total number of tasks, 6 (which includes A.1, A.1.1, A.2, A.2.1, A.2.2, B.1) by the total number of 100% completed tasks, 3 (which are A.1, A.1.1, A.2.1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!