How can I look up a set of values in a column for a dashboard metric?

Loukas W

The end result: I want a metric on a dashboard to show rows of a sheet that meet certain criteria.

Background: I have a sheet that has, among other things, a column that shows quantities of an item from a form (using the sheet as a survey response form). I want to find any rows that have a value of 10 or less, and show those rows in a Metric widget on a dashboard. How can I accomplish this? I can use a "COUNTIF" function, but that only gives the number of rows that meet the "10 or less" criteria, not which rows specifically. I want the specific rows.

Additionally, I don't need/want to show the entire row in the Metric widget, only the Quantity value, and the Location Code value from a different column.

Paul Newcome

I would suggest creating a report and then displaying the report on the dashboard.

Loukas W

That worked, thank you!

Paul Newcome

I would suggest creating a report and then displaying the report on the dashboard.

Loukas W

That worked, thank you!

Paul Newcome

Happy to help. 👍️

Marie.DeFelice

I added an additional column to the Portfolio Metrics report and copied the formula however the new column is not displaying on the dashboard. How do I get the new column to show?

Genevieve P.

Hi @Marie.DeFelice

If you're using Metric Widgets, you'll need to either add a new widget for the new column or Edit the current widget to add the new data 🙂