Filtering the two largest numbers

Eden

Eden ✭✭

11/23/23 in Smartsheet Basics

I want to display only the two largest numbers in the sheet in a chart in Dashboard, can you please tell me how I can do that?

0 ·

Best Answer

Royce. ✭✭

11/23/23 Answer ✓

Make a new (helper) column that pulls the two largest values, =LARGE(range, value position). Then refer to that column in your dashboard chart.

1 · Share on Facebook Share on Twitter

Answers

Royce. ✭✭

11/23/23 Answer ✓

Make a new (helper) column that pulls the two largest values, =LARGE(range, value position). Then refer to that column in your dashboard chart.

1 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

WORKSPACE PANEL - Automatically open when going to a new sheet / report / dashboard
This panel seems to automatically be open when navigating to a new sheet / report / dashboard in the directory. Is this a change? Is there a way to deactivate that being open automatically? thank you, Dave
Do I really have to make the same change on every single one of my sheets separately?
Hi Folks - I'm pretty much a newbie to SS, but I have already created 20+ different sheets for each of my projects, using a template. Now, if I want to make a change to the structure of all the sheets (ie, change the name of a column, add an alert, or anything really!)… is there not a way to automatically make the same…
My automation doesn't send me an email with vertical details; instead I get a very small part of the
I am so frustrated I feel like tearing out my hair! I created this automation: I want to send an email that has all the fields with the information vertical to flow like an email. It worked fine for a week but now I am seeing this: So I only see the first few columns and nothing else. How do I get it back to the way it was…

Help shape the future of Smartsheet.
Share your ideas and feature requests.