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

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    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

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    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.

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