Dashboard count only if rows filled from a reference sheet
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.
Answers
-
Are you able to provide some screenshots for context?
-
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.
-
In that case you would just use a COUNT function and reference each column separately.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!