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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives