Workflow not triggered when row changes

hreddens · 12/10/24

I have a two workflows to update Status and %Complete when either is changed by the user.

For example; If %Complete is not 100% and Status is changed to Complete, then update %Complete to 100%.

The trigger does not activate and row values do not change.

Is there a delay or some other action needed to trigger?

markkrebs · 12/10/24

is status derived with a column formula? if so, it wont trigger

hreddens · 12/10/24

Status is a dropdown

In Process

Not Started

Complete

markkrebs · 12/10/24

Cells that contain cross-sheet formulas or cell links won’t trigger a workflow that automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, Approval Request). To work around this, consider using time-based automation or recurrence workflows.

hreddens · 12/10/24

There are no cross-sheet formulas or cell links.

markkrebs · 12/10/24

I dont think you need the condition since you want to set it to 100. Try deleting the condition and see what occurs.

hreddens · 12/10/24

It is based on this;

hreddens · 12/10/24

Thanks,

I tried deleting the condition but it had no effect.

When I change either column, it does not update the other.

hreddens · 12/10/24

Is this the correct setting?

markkrebs · 12/10/24

that shouldn't matter - I recreated and it worked for me. is the % complete a text/ number column? if not, any value restrictions?

hreddens · 12/10/24

It is text/number.

Do you think the Condition should be 1 instead of 100%

markkrebs · 12/10/24

could try it but I dont think thats the issue. I'd have to see the sheet and what its doing. did you run a test automation?

hreddens · 12/10/24

I have a simple test Sheet with the same issues.

How can I share it with you?

markkrebs · 12/10/24

mkrebs@alixpartners.com

Answers