Workflow to COPY Row when there's ANY Change

Christine Cao

Hello

I'm trying to figure out WHY this workflow is not working in all trigger scenarios. it works when the columns have a specific value selected such as when STATUS Changes to one of the select values defined but when criteria is ANY VALUE change in the column, it does not trigger the workflow.

Example Below - I want the workflow to trigger when STATUS UPDATE column is updated, changes to "ANY VALUE". NOTE - There's no specific value because it's a free form text field.

Another example - when % Complete is updated. This column pulls in from the Project Plan % Complete through cell link. So when this % value changes, I want the workflow to trigger.

Is this doable? Does anyone see any issues with this workflow and how it's set up. I don't know know how else to set it up.

Complete Workflow set-up is below:

Paul Newcome

I understand that you have a few fields that are not linked like that, but I believe the issue is because you do have some fields in the trigger. Try removing those linked fields and leaving only those fields that are manual entry to test this.

Paul Newcome

Workflows cannot be triggered by cells containing cell links or cross sheet references or cells that are referencing another cell that contains a cell link or cross sheet reference.

Christine Cao

@Paul Newcome Thank you for that info Paul. But what about the cell that is just a text field. The STATUS UPDATE cell is not linked to another. It's a free form text cell where someone enters their update. I want the trigger to occur when they update that cell at a bare minimum. Can I make the workflow trigger with the condition? Thank you again

Christine

Genevieve P.

Hey @Christine Cao

Is there any possibility that the SOW # is not seen as a number in the sheet?

To check: numbers appear on the right-hand side of the cell, text appears on the left.

You can also use a formula to check cells in your column to see if they're being recognized as a number:

=IF(ISNUMBER([SOW #]@row), "Yes", "No")

Let us know if this helped! If not, it would be useful to see a screen capture of your sheet, but please block out sensitive data.

Cheers,

Genevieve

Paul Newcome

I understand that you have a few fields that are not linked like that, but I believe the issue is because you do have some fields in the trigger. Try removing those linked fields and leaving only those fields that are manual entry to test this.

Christine Cao

@Paul Newcome Thank you Paul. That fixed the problem. Removing those that are linked fields.

Paul Newcome

Happy to help. 👍