Parent and child sorting issues
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?
Best Answer
-
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.
Answers
-
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 Thanks the Sheet Summary worked great I didnt know about that.
