Can I hide a row once a status is marked as complete in a column using conditional formatting?
Answers
-
You can via filters but it doesn't have the functionality like Excel. The filter would be to exclude anything in Status that says Closed.
One thing I did for this same need is just have those rows moved to an identical sheet so it captured the data and had the formulas removed. Reason for this is that certain look up information changes at times and I wanted to keep the original data that particular row/s had when it was completed.
-
Thank you! I am extremely new to Smartsheet. Can you please elaborate on how to move rows to an identical sheet? Thanks again
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives