nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Return top 5 entries in a report

SimonT

I am trying to set a report to only return the top 5 entries in a sheet based on a sort criteria, Does anyone know how this can be achieved?

Thanks in advance

Find more posts tagged with

Reports

Project Management

Comments

Paul Newcome

You would need to set up a table and reference your data using a LARGE function.

Mike Wilday

Here is some additional data on using the Large function.

https://help.smartsheet.com/function/large

SimonT

Thanks for your help Paul

SimonT

Hi Mike

Answered my next question before I had even asked it, perfect! Thanks

Mike Wilday

You're welcome! Let us know if you have any other questions.

SimonT

Ok so now I have the top 5 values for one column..... but can I return multiple columns from that row? For example the names, values and country of the top 5 customers by order value.

Paul Newcome

Thanks for the cover, Mike. I had copied the same link to add to my comment, got busy before I hit submit, then forgot to put the link in when I came back to it. It's been a "fun" week.

Paul Newcome

There are a few different options. The easiest one would be to build the LARGE function into an IF statement in a checkbox column that will automatically check the box if that person is in the top 5. You can then create a report that pulls the rows based on having that box checked.

Mike Wilday

Haha. I understand those types of week. I think I've had one of those years.

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…