Change cell value automation

Charles_M

I am trying to change a task to started if there is time in the duration column. The duration comes from a cross-sheet formula, I know this automation cannot be triggered by a cross-sheet formula so I setup a duration helper column to be the trigger from the same sheet, but it still does not change the cell value. I want the status column below to changed to started when teh Hours Worked helper is more than 0. Hours worked helper column formula is =[Total Hours Worked]@cell. I can't use formula because the status will be manually set to on hold or complete.

Here is the workflow:

kowal

Hi Charles,

What about making bit simpler "if" formula in Hours Worked Helper column to be only checkbox.

=if([Total Hours Worked]@row=0, 0, 1) so if the hours in total hours worked are different to 0 it will check the box in helper so you can setup a workflow to be triggered and change the status to "Started" when helper will be checked.

Let me know if it helps.