Workflow not triggered when row changes

hreddens

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

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

hreddens

Status is a dropdown

In Process

Not Started

Complete

markkrebs

• 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.

Automate processes with workflows | Smartsheet Learning Center

hreddens

There are no cross-sheet formulas or cell links.

markkrebs

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

hreddens

It is based on this;

How Do I link the Status Column to the % Complete Column?

BArmendariz

Jul 30, 2023

I am looking for a formula that will allow me to update the Status Column (not Schedule Health) to update based on the % Complete (or vice-versa).

Example: If the % Complete is updated to 100% the Status should auto-update to Complete. If the % Complete is anything between greater than 0% and less than 100% the status should update to In Progress.

Alternatively, if the Status is updated to Complete, then the % Complete should be auto-updated to 100%.

Any insight is appreciated.

---

View Post

hreddens

Thanks,

I tried deleting the condition but it had no effect.

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

hreddens

Is this the correct setting?

markkrebs

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

hreddens

It is text/number.

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

markkrebs

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

I have a simple test Sheet with the same issues.

How can I share it with you?

markkrebs

mkrebs@alixpartners.com