Dashboard count only if rows filled from a reference sheet

Victor CH Iberostar

Hi.

I am working on a dashboad to summarize some data from a reference sheet. I want to add a metrics widget that presents a sum of the number of rows on a reference sheet only if they are filled with a color completely.

Details:

I have a sheet with different project rows filled in green, indented under those are 'tasks' filled in blue and indented again, 'subtasks' left blank. I want the metrics widget on the Dashboard to summarize the number of projects, tasks, and subtasks. I was thinking that I could use =countif(select the entire sheet),"green' but didn't work. Any help in fixing this formula?

Or is it better to go based on the colums since the first column is the projects column, the second is the tasks and the 3rd is the subtasks?

Thanks.

Paul Newcome

Are you able to provide some screenshots for context?

Victor CH Iberostar

Thanks Paul

As you can see from the image below. I have 3 columns identified as Projects, Tasks, and Substasks. Using just what's visible in the sheet below as an example. I want the widget to be able to count how many are filled in green and give me a count, then do the same for the ones in blue and the same for the ones in white. This would allow me to keep track of how many subtasks, tasks and projects the staff have.

From the image below, I would count 4 projects, at least 2 tasks, and 5 subtasks.

Hope it helps and thanks again.

Paul Newcome

In that case you would just use a COUNT function and reference each column separately.