I need to retrieve a row in a master smartsheet. I can see  that row in a report output, but cannot see it in the source sheet. In the master sheet row number jumps from 266 to 268 and it's 267 that I need. On the other hand, you can't hide, and therefore unhide rows as such, the only thing I can think of is that I may have applied some filters that can hide pieces of data - in this case the row in question. I've checked all filters on the master and still cannot spot anything to give me a clue where to look.

Can you help, do you have any tips?




Hi Alina,

Are there any filter active when the row numbers jump? If not, It shouldn't hide anything because it's not possible.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Have a fantastic week!


Andrée Starå

Workflow Consultant @ Get Done Consulting

I know this is solved, but as a reference for other people trying to solve the same problem it is possible to hide row without a filter, and it is something I do very often at the top of my sheets. What I do is post my calculations at the top of the sheet, then use a parent child relationship to collapse my rows, then hide the primary column. This way my users never have to deal with the calculations, and the *often* large amount of space they can take up, and I don't have to worry about my formulas breaking.


Just something else to look out for when you are trying to find missing rows.