Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is there a way to hide a completed row (% Completion Column) in a project?
Using a project smart sheet with Gantt functionality, I would like to be able to hide competed tasks in the project sheet. It is used for production scheduling so the once a task is completed it is not needed to be viewed again unless desired. Note... predecessors are used so deletion of the task is not desirable.
Comments
-
Apply a filter for % Completion is not 100%. Recognize, too, that mathematically, 100% = 1.00.
-
Worked well.
Thank you kindly!
-
Glad to hear it. We do the same thing (and a whole lot more) with our production schedule.
-
Along these lines, is there a way to write a formula that would move a line once marked "Complete" to another sheet?
Blessings,
Loann
-
Loann, there isn’t a built in function that will do this, but you could use Zapier which utilizes our API to perform automated actions. You could set up a Zap that would copy (not move) the contents of that row to another sheet if you mark a task as "Complete". Check out zapier.com for more information.
-
Hmmm...the dept asking needs it to be moved off the sheet to an archive sheet.
Looks like doing it the old-fashioned way is the route we'll need to go.
Thanks, Travis!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives