FORMULA TO COUNT ITEMS NOT COMPLETE BY PARENT ROW
I have 5 main parents with some smaller indents.
Pre-Explore (one of the 5 main sections) within that I have a parent meetings with children and several other parents with no children.
I have a % complete column we are manually filling out.
I'd like to be able to show just the 5 main sections and provide a number of total uncomplete items. I can do this in a report but wanted to add it to my dashboard as a metric.
Is this possible?
Answers
-
You would need a column with the following column formula:
=COUNT(ANCESTORS())
Then in your metrics sheet, you would incorporate this column into your formula(s).
-
The main row is showing zero (pre-explore) I included a screen shot for you. What I'd like to show on my dashboard is how many items based on Pre-explore, explore are incomplete. The screen shot shows the formula provided in the help column. I'm not sure it's working the way I wanted, I don't think I explained it very well.
-
My apologies. I misread your initial post. Based on your screenshot above, exactly which rows should be counted? Those on level 1, those on level 2, or both?
-
Not sure what level 1, level 2 are, sorry. I would want to show on pre-explore 3 that are not complete,
on explore 4 (including the seasonal planning item), these are all not at 100%.
Does that help?
-
It looks like the "help" column is denoting which level of hierarchy each row is on. Do you want rows that have a 1 in that column, a 2 in that column, or rows that are either 1 or 2?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!