% Complete in a Filtered Schedule
Hello! I am new to smartsheet and am having an issue. We have a schedule where we have several different project type options. Depending on the project type, the project types that are not applicable to that project are filtered out and hidden. So there are several hidden tasks in each of our schedules. The problem I am having is with the % complete column on the parent row. It is calculating the hidden filtered tasks, so it is skewing the % complete for the tasks that are in view. Is there a way to mark those tasks that are hidden as 100%, or not count those tasks in the calculation?
Thank you!
Comments
-
Hello,
As you have found, the parent rollup functionality takes into account all children rows, and doesn’t exclude hidden rows. If you’d like to allocate 100% to hidden tasks, you’ll have to do so manually. I think these are great suggestions and I encourage you to submit this feedback to our Product team directly using the Product Enhancement Request form (you’ll find a link to this here in Community under Quick links on the right).
-
Thank you for your response. I will do that.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives