How can I look up a set of values in a column for a dashboard metric?
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.
Best Answers
-
I would suggest creating a report and then displaying the report on the dashboard.
-
That worked, thank you!
Answers
-
I would suggest creating a report and then displaying the report on the dashboard.
-
That worked, thank you!
-
Happy to help. 👍️
-
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?
-
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 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!