Work Insights
Does anyone know what the filter syntax is for only fields that contain values? I'm try to exclude blank columns and it keeps recognizing rows that have filters in them. I'm try to get the work insight graphs to show only rows that have a drop-down choice selected.
Answers
-
Try creating a report from your sheet and make a graph on a dashboard from that. Within the report setup you can exclude blank columns.
-
I saw your other posts about Work Insights and filtering what appear to be blank cells as well. I believe that what you're experiencing is that the formula in the cells means that the row isn't considered as "blank" for the filter, but the output of the formula is a blank cell so it's still appearing in your Insight graph as a value.
I would recommend adding a helper dropdown column to your sheet with a formula in it, that checks your other column and returns text that you can filter on, like so:
=IF([Column Name]@row = "", "Exclude", "Include")
Then tomorrow you can filter based on if this helper column says "Include". This should filter out your formula rows and blank rows from your Insight chart.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives