Data: set the values of some columns in this row to changes in specific column only

[Peter_S1 (Peter)]

Hi,

I’ve created an action with Data: set the values of some columns in this row to insert today’s date when the a value of a Status column equals to Completed. Then in the Workflow I have the Update Event to Updates_Only and set the condition to [Status]=Completed.

So the above works and it inserts today’s date when the Status is changed to Completed. The issue is that when any sort of change takes place in that table (to other columns) it triggers the action. For instance, when a start date is changed, it would update the completion date today. Is there away to have the action trigger only if the change occurs to a specific column (status column only in this case).

[Suvrutt_Gurjar]

Please consider following

Option 1

@Peter_S1

Then in the Workflow I have the Update Event to Updates_Only and set the condition to [Status]=Completed.

@Peter_S1

The issue is that when any sort of change takes place in that table (to other columns) it triggers the action.

Are the other columns changing after the Status column has moved to “Completed” status? That is probably happening because the workflow condition [Status]=Completed is true in all cases on all updates. Please consider a workflow condition something like
AND(
[_THISROW_BEFORE].[Status]<>[_THISROW_AFTER].[Status], [_THISROW_AFTER].[Status]=“Completed”
)

It will ensure the workflow listens to only changes in the [Status] column
Please refer below relevant post and article referred therein

Workflow fires when Image column stays empty

I have a Workflow that fires a Data Change Action. Updates only. My workflow condition is: [_THISROW_BEFORE].[Image]<>[_THISROW_AFTER].[Image] When the image column is empty and I edit another column, the workflow will fire, even though there was no change in the image column. If there is an image and I edit another column, the workflow will not fire. The only workaround I found is to change the condition: AND( ISNOTBLANK([Image]), [_THISROW_BEFORE].[Image]<>[_THISROW_AFTER].[Image] )…

Option 2
Another alternative you could explore is to use the Changetimestamp type column for your requirement that listens to changes in the status column and captures the change date.

Tracking Changes Using "Change" Column Types

https://www.appsheet.com/samples/Keep-track-of-when-columns-change?appGuidString=8a1572da-c548-418c-8767-a04482f2f7ed

[Peter_S1 (Peter)]

Thank you, Suvrutt, option 1 works! Appreciate the help.