Look up formula in workflow condition

[Mohd_Nur_Arief]

So i have a table called “Customer Acknowledgement” that is referred to a table called “Details” (Table “Customer acknowledgement” Is part of table “Details”). I’ve set a workflow to fire when column “status” from table “Customer Acknowledgement” is equal to “Completed” and the update event is set to UPDATES_ONLY. but im not sure why it is not triggering when i update the status of the customer acknowledgement

The formula is:
LOOKUP([_THISROW].[ID],“Customer acknowledgement”,“Customer Acknowledgement ID”,“Status”)=“Completed”

[Aleksi]

It won’t work because you are not triggering the record itself from the Details table. You need to trigger the detail record somehow and one option is an Event action when the Customer Acknowledgement record is created or updated.