SmartSheet Filter Issue - Please Help!

edited 01/10/23 in Formulas and Functions

Hello all,

I've run into an issue where one of my users added a filter called "Filter" to a sheet that has caused an issue. I'm looking for some help.

When the filter is ON, the sheet has 900 rows full of data. When I turn the filter OFF, the sheet only displays 10 rows of data. I have included a screenshot of the filter's settings below. This is the only filter in the sheet.

If I try to delete the filter (so there are no filters remaining on the sheet), I am left with only 10 rows of data. All the other data disappears. For the life of me I cannot understand why disabling / removing / deleting this filter is hiding data. Based on the settings of the filter, it seems that removing it should display more data, not less.

I want to remove the filter and just have ALL my data visible. How can I do this?

Best Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Are there any other filters built into the sheet? Have you tried scrolling all the way down to the bottom of the sheet when the filter has been turned off to see if maybe the filter is just getting rid of a bunch of blank rows?

  • gjohnson.pcpro
    Answer ✓


    You're the man. I scrolled down (past several hundred blank rows) and my data was there. I'm not sure how all these rows ended up in the sheet, but I will remove them and that should take care of it.

    Thank you so much for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!