Is there a way to use Automation to update a Duration column?

I have a helper column currently that checks to see if a task is required or not, and I want to set my duration to 0d if it is not required. Right now, I am doing this manually as I can't see a way to get automation to update a Duration column using the "Change a Cell Value" option. Is there a way to do this via Automation?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!