Dashboard count only if rows filled from a reference sheet



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.


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!