Gantt Chart smarts
Hello Brains trust,
I have added a checkbox column "Not Applicable to this Plan" to a template project plan.
I want the task to stay in the list so that there is a clear indication that this task was considered and then a decision made that it was not relevant. But I want the task ignored in terms of % progress etc.
When I go to write an automation to I can choose "Change Cell Value" but the options for the columns I can change the value of is limited. e.g. I cannot change the duration to 0, nor the start or finish date.
I can also "Clear Cell Value" but it does not work in all cells. i.e. it wont clear predecessors, it wont clear duration unless duration is zero, and then it resets it to one.
About the only thing I can make it do is change % Complete to 100%.
This then makes my progress bar look deceptive (i.e. some of these tasks would, if undertaken take weeks, whereas many other tasks are only 1 day or less.