How can I automatically remove data with a value of zero from a Dashboard

kgeraght

I am looking for a formula to remove any line of data that has a value of zero in the Report, from the Dashboard. So, when the line of data is zero in the Report, it should eliminate that row from the Dashboard.

Paul Newcome

You would include a filter in the report itself to not show any row containing a zero.

kgeraght

So actually my Report is being used to create a count (COUNTIF formula) into a Sheet, and that Sheet is flowing into the Dashboard. So perhaps I need to amend my formula?

Paul Newcome

You cannot reference a report in a cross sheet reference. Are you able to provide some screenshots and maybe more details as to how data is flowing?

kgeraght

Here is my formula: =COUNTIF({NAME OF SHEET Sponsor columns}, [Primary Column]@row). Does that help? You're right that the Report isn't used in the sheet - I am still new at this and trying to remember how I got things to work!

Paul Newcome

So what exactly is feeding the dashboard? The sheet or a report?

kgeraght

The Sheet with the formula I posted is feeding a Chart widget on the dashboard.

Paul Newcome

Ok. In that case you would create a row report that is fed by the sheet and include a filter to only show rows where the number is greater than zero. Then you would use the report to populate the chart.

kgeraght

Thank you, that worked! Really appreciate your help and patience.

Paul Newcome

Happy to help. 👍️