Parent and child sorting issues

LeoCicio

I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?

Nick Korna

It may depend on what you are sorting/filtering by as to whether a helper column would assist - for example if you're sorting by 3 criteria at once you wouldn't be able to add another.

Alternatively, you could have your metrics in the sheet summary instead (and if necessary spin these off into a report/dashboard) so that the main body of the sheet only contains data.

Nick Korna

It may depend on what you are sorting/filtering by as to whether a helper column would assist - for example if you're sorting by 3 criteria at once you wouldn't be able to add another.

Alternatively, you could have your metrics in the sheet summary instead (and if necessary spin these off into a report/dashboard) so that the main body of the sheet only contains data.

LeoCicio

Nick Thanks the Sheet Summary worked great I didnt know about that.