SmartSheet Filter Issue - Please Help!

gjohnson.pcpro

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?

Paul Newcome

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

Paul,

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!

Paul Newcome

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

Paul,

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!

Paul Newcome

Happy to help. 👍️