How to Child (Level 2) Data Complete Vs. Incomplete?
I have many of these parent (Level 1) rows that are completed as the Level 3 rows underneath it are completed. Under the parent, Level 1, row, is a Level 2 row that is directly tied to certain Level 3 rows. How could I create a Pie Chart displaying all of the Level 2 Rows Complete/Incomplete totals?
Best Answer
-
Hi @Curculese
You've made this easy since you identify the Level in one of your columns! 🙂
To create a Pie Chart you'll need both numbers: Level 2 rows not complete, Level 2 rows complete.
=COUNTIFS([Level Column]:[Level Column], "Level 2", [% Complete]:[% Complete], <> 1)
and
=COUNTIFS([Level Column]:[Level Column], "Level 2", [% Complete]:[% Complete], 1)
You'll need to change out the column names to match your names, and I'm assuming you want to use the percent complete column (100%) to indicate if something is done.
You could put these formulas in 2 Sheet Summary fields, then use a Sheet Summary Report to surface these 2 data points side-by-side, and use that as the source for your Chart.
Cheers,
GenevieveJoin us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @Curculese
You've made this easy since you identify the Level in one of your columns! 🙂
To create a Pie Chart you'll need both numbers: Level 2 rows not complete, Level 2 rows complete.
=COUNTIFS([Level Column]:[Level Column], "Level 2", [% Complete]:[% Complete], <> 1)
and
=COUNTIFS([Level Column]:[Level Column], "Level 2", [% Complete]:[% Complete], 1)
You'll need to change out the column names to match your names, and I'm assuming you want to use the percent complete column (100%) to indicate if something is done.
You could put these formulas in 2 Sheet Summary fields, then use a Sheet Summary Report to surface these 2 data points side-by-side, and use that as the source for your Chart.
Cheers,
GenevieveJoin us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Very easy instructions. Thank you!!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives