Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Getting top x rows

06/29/17 Edited 12/09/19

Hi all

We're working on a dashboard for senior stakeholders. At the moment we have a report that is an amalgamation of several sheets (listing risks & issues). We now want to limit that amalgamated report to only show top x rows, based on one of the columns (numerical value). 

 

So, instead of the current report showing all risks & issues (from the various base sheets), we want to just show the top 7.

 

Is this possible?

Comments

  • Hi dharmesh,

    One way to do this, since report criteria can't pull in a specific number of rows, is to add an auto number column to your sheets and give the column a starting number of 1. (More on auto-number columns in our help center.

    You can then adjust the What? criteria of your report builder form to pull in rows from your sheets if the auto-number column contains values between 1 and 7.

    This will pull in the top 7 rows from every sheet.

    If you're looking to pull in only seven rows period, that's a little tricker as reports can't perform calculations at this time. You may need to come up with a "rating" function that rates your risks so that the top seven highly weighted risks from all sheets will likely come into the report. Details on functions available to Smartsheet can be found here: https;//help.smartsheet.com/functions

This discussion has been closed.