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.
I have a report that is referencing a control center program. Other users that are setup as leads on the program and have the same admin permissions I do are able to edit the Group, Filter, Summarize and Sort settings of this report, but I can not. When I click the Columns button it just says "Loading" and even if I leave…
I wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…
I have 165 projects in the portfolio, each with 5 gates and ~120 steps in a project. As an example if a project has successfully passed gates 1&2 and is coming up on gate 3 review, I want to be able to see the rollup at the portfolio then "zoom in" to see the project plan details for a specific project and gate 3. With my…
