AGAIN, .... please help, I would appreciate an answer!
How to pick just certain tasks, but still keeping the correct timeline?
Porzel Hans ✭✭✭✭
Dear all,
I have a project plan that contains a number of tasks.
In this project plan is a column, called "Necessity". It's a checkbox.
Some tasks at the project plan are necessary, some are not, depending if the checkbox is checked or not, either.
Then the filter get's applied to this column of the checkbox.
The filter works fine.
BUT, and this is now the bother, - but the Gantt-Chart still shows the gap between the successor bar. That means for me as a project manager that I haven't gained any time by shortening the timeline.
For that reason I have the question: Is there a formula possible that might take into consideration to ignore un-necessary marked tasks?
The screen shots beneath these lines might help to understand what I mean.
My heartfelt thanks to everybody who might suggest a possible solution. Every comment or hint will be greatly appreciated!
Best regards
Hans P. ... from Germany
Picture #1: Before filtering
Picture #2: Filtered, according "Necessity" checkbox. But Task #6 does not connect to Task #3. So, no gain of time at the time schedule.
Picture #3: The green colored bar shows the desired result.
Answers
-
Start by trying to update the predecessors so that rows that are necessary do not have a predecessor of a row that is not. For example, Quote Release has a predecessor of Sample Testing. If you do not need Sample Testing, then Quote Release should not be dependent on it.
-
Hello Paul,
Thank you dearly for your answer, it's greatly appreciated!
Best regards
Hans P. ... from Germany
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!