Creating a Rule to Automically Hide Rows
Is it possible to create a Rule, Conditional Formatting, or Workflow where when you check off a Box on the sheet it then hides that row?
If not, can I request this feature from SmartSheet?
Thank you
Best Answer
-
Hi Cesar
There isn't an automation to hide in the sheet, and rows themselves cannot be hidden. Depending on who you want to hide them from, or why, your best bet would be to use a report off the sheet.
Add a helper column to the sheet (e.g. Hide Row), make it a checkbox. You could then either manually check the rows you want hidden OR create an automation to set the value to checked on a specific condition - like the reason you want it hidden
Create a report with the columns you want and set a filter to include rows where Hide Row value is Not Checked.
I've used this (and variations of it) in the past and works well as I never have users editing directly in the master sheet, they have have report views to see/update the content.
Shawn
Answers
-
Hi Cesar
There isn't an automation to hide in the sheet, and rows themselves cannot be hidden. Depending on who you want to hide them from, or why, your best bet would be to use a report off the sheet.
Add a helper column to the sheet (e.g. Hide Row), make it a checkbox. You could then either manually check the rows you want hidden OR create an automation to set the value to checked on a specific condition - like the reason you want it hidden
Create a report with the columns you want and set a filter to include rows where Hide Row value is Not Checked.
I've used this (and variations of it) in the past and works well as I never have users editing directly in the master sheet, they have have report views to see/update the content.
Shawn
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!