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

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

Please consider following

Option 1

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

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.

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

2 Likes

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

2 Likes