Automate duration values based on a particular selection made in a form

Grace H

I'd like to automate timings put into the duration column (shorter than days, e.g. 3 hours, etc.) based on selections made in a form submission to a sheet. Alternatively, setting up an automated workflow in the sheet that will automate timings in the duration column. again based on a particular selection being made.

Brewso

Hello Grace, Have you found a solution? I have the same need where depending on the staus of a task, if I make it not applicable, I would like the duration to be adjusted to 0d, please let me know! Thanking you in advance!