Can i exclude first 25 and last 25 rows from a Column, and also seperate the middle rows to a sheet


I have a Line count of 100 rows in specific sheet, i want only 50 rows from 26 to 75, which intern excludes first 25 and last 25 rows, and also can i seperate the file with the middle 50 rows


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @Manjunath Vijayakumar ,

    Add a helper column [row] to your sheet. Number your rows 1-100 in that column. Or, use autonumber system cumn to do the same. Then create a report for the sheet. Set the report filter to select [Row] with a value between 26 to 75. Add the other columns you want visible in the report.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Thanks mark, this works out for static data, if the data is dynamic and changes from 100 to higher value or 100 to lower where we need only first 25% of the total rows

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!