Formula for Status Summary Report and Project Task Completion
Hi Smartsheet Team,
I have the following charts. Left one, I retrieve the data from Status Summary Report. On the right side, I have the formula to calculate the Project task completion. However, you will see the complete % is different between these 2.
My "Not Started" in Sheet Summary formula is =COUNTIFS([Count of Children]:[Count of Children], =0, Status:Status, "Not Started"). Can you advise how I can make these 2 charts figures consistent? Thanks!
Answers
-
Hi There,
Both of the values might not be consistent as the % Complete formula (that is auto applied) looks at duration and not just the number of tasks. In comparison, your countif formula is only looking at the number of tasks. A suggestion to best represent both of them without causing this confusion would be to show the "Tasks by Status" chart as absolute numbers (i.e., number of tasks by status instead of percentages) and leave the "Project Task Completion" as a percentage.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Good Idea, Aravind. Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives