Unhide row

Alina

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?

Andrée Starå

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, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Alina

Thanks, done. 

Andrée Starå

Happy to help!

I'll take a look and get back to you!

Best,

Andrée

Andrée Starå

It looks correct when I look at it!

Can you share a screenshot on how it looks for you?

Best,

Andrée

L_123

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.

handmadetsunami

Hi,

 

Can you explain this is more detail please? Or provide screenshots as it sounds like it could be useful but I can't understand the way you have described it

 

Thanks