Hi
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
You would need to set up a table and reference your data using a LARGE function.
Here is some additional data on using the Large function.
https://help.smartsheet.com/function/large
Thanks for your help Paul
Hi Mike
Answered my next question before I had even asked it, perfect! Thanks
You're welcome! Let us know if you have any other questions.
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.
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.
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.
Haha. I understand those types of week. I think I've had one of those years.
One of our employees recently got married and changed her name. She now has a new email address. What is the best way to update this in the Admin Center? If I add the new email as an alternate email, can I make that one the primary? Will this impact any assets that are owned by her?
I have a work plan in a sheet with a Checkbox column to denote where major decisions are required and a separate sheet working as a RAID log. Is there an equation or automation that would allow me to automatically in the RAID log based on the checkbox? Ideally I'd only want to fill in the relevant columns that are in the…
This discussion was created from comments split from: Grouped Reports with multi-select dropdowns.
