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
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives