Sign in to join the conversation:
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.
Hello, I have a metrics reporting sheet that relies on cross sheet reference formula to count rows from a formula column in a source sheet (let's call it Sheet A) that refreshes with data via data shuttle (set to 'Replace all target sheet rows with the data from the input file') once per day at 8 AM UTC (I am in PST). One…
Dear Community, I have created a form where the contact field is mandatory. If no value is selected in this field, the form correctly shows the error message: “This response is required.” However, if I select a name and then remove it, the field shows a remaining circular icon, and the form gets submitted without any…
I have no idea how to start the program. I need the basics on how to build charts and graphs.
