Blank Field Not Displaying on a Dashboard Widget
Hey everyone,
I'm trying to create a pie chart on a dashboard that shows Project Types. We have 4 types in a drop down field in the sheet. As a default, when a row is added the field is blank.
I built a report that summarizes that field and on the report it shows "Blank" but it won't pick it up on the chart, but I want it to.
Anyone have any ideas on how to fix this?
Thanks!
Best Answer
-
I don't know if this is the best way or most efficient, but this is how I handle these.
Using the sheet summary, you can write formulas to search that column to find any type 1, 2, 3, 4, or blank. For this to work, you need to have another always-filled column, like a project name column. Otherwise, it also counts rows that you are not currently using. Then use a summary report to pull all those numbers, then feed that into your pie chart.
=COUNTIFS([Project Name]:[Project Name], <> "", [Project Type]:[Project Type], "")
This formula will count all the projects with the name column filled in, but the type is blank.
Answers
-
I don't know if this is the best way or most efficient, but this is how I handle these.
Using the sheet summary, you can write formulas to search that column to find any type 1, 2, 3, 4, or blank. For this to work, you need to have another always-filled column, like a project name column. Otherwise, it also counts rows that you are not currently using. Then use a summary report to pull all those numbers, then feed that into your pie chart.
=COUNTIFS([Project Name]:[Project Name], <> "", [Project Type]:[Project Type], "")
This formula will count all the projects with the name column filled in, but the type is blank.
-
awesome, thank you!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives