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; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

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

FORMS | Make 'Send me a copy of my responses' to be View Only
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
Automation
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
URGENT: Pro Subscription Not Recognized – Immediate Staff Contact Required
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…