Is there a way to have the data within a Metric Widget to be sorted automatically in order?

rmiro

I have data that is being ranked in order of how many errors occurring from most to least. I've organized these in the summary sheet of the reference sheet however currently I have to manually move the data by dragging them individually in the Metric Widget. Since my report could change based on the number of errors occurring, I was wondering if this can be automated within the Metric Widget?

Humashankar

Hi @rmiro

Automatically sorting data within a Metric Widget is not feasible.

Would you like to try a combination of formulas and conditional formatting in the underlying data sheet to automatically update the sorting.

Ø For example, you can use a formula like =RANK(A2, errors_column, DESC) to rank the errors in descending order, and then use conditional formatting to hide or show rows based on a threshold (e.g., only show top 5 errors).

Ø To add more brightness - use a formula column to calculate the rank or priority of each row based on the number of errors occurring.

Ø You can use functions like RANK or SORT combined with COUNTIF or other relevant functions to dynamically sort the data.

Out of this method when the data changes, the sorting and ranking will automatically update, and the Metric Widget will reflect the changes without any manual intervention.

Hope this helps - Happy to help further!!

Thank you very much and have a great one!

Warm regards

Andrée Starå

Hi @rmiro

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Humashankar

Unfortunately, what you're suggesting doesn't work in Smartsheet because it's formatted for Excel.

Smartsheet doesn't, for example, have the SORT function.

rmiro

@Humashankar @Andrée Starå Thank you both for your help and suggestions!

I do have a formula column to rank the errors and they have been sorted within the column. I've only manually sorted the ranking within the summary sheet and that is reflected in the Metric Widget.

Andrée Starå

@rmiro

Happy to help!

Yes, I missed that if you use a formula structure, you could have it populate the metric widget in the order you want.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!