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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!