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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives