Master Table contains child table records.
Master Table has one formula field and value as initially “Incomplete” and once the child table records completed, the formula filed value will change as “Completed”.
I set a workflow on Master Table with “ALL_CHANGES” and tried with different type of conditions like
[Inspection Status] = “Completed”
[_THISROW_BEFORE].[Inspection Status]<> [_THISROW_AFTER].[Inspection Status],
[_THISROW].[Inspection Status] = “Completed”
There is no system error but workflow not triggered when the value has been changed. In Audit log, there is no such event occurred.
The below is the formula to set value for “Inspection Status”.
IF(COUNT(SELECT(Inspection Template[Checkpoint], [Fleet Type]= [_THISROW].[Fleet Type])) = [Questions Attended], “Completed”, “Incomplete”)