Set Duration to 0d with automation
We have a project template sheet with default tasks, durations, predecessors, etc. When a user saves the template as a new project they can then decide which tasks are not relevant to that project by marking unneeded tasks as 'N/A' in a Status dropdown list column.
We created a 'Clear Cell Value' automation to clear the Duration field on a task when the Status is changed to 'N/A', however, it does not work (i.e. nothing happens). We do have (and need) Dependency Settings turned on for the project. I looked at changing the automation action to 'Change cell value' but Duration is not available for that time of action.
I've seen other posts similar to this but don't recall seeing any recent updates. I'd be interested to know what workarounds exist as well. Thank you!