FORMULA TO COUNT ITEMS NOT COMPLETE BY PARENT ROW

BLAVA

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?

Paul Newcome

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).

BLAVA

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.

Paul Newcome

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?

BLAVA

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?

Paul Newcome

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?