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
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives