Changing a Work Order Status

[rmsmeltz]

I’m creating a bot to update the status column of the parent table to “reconcile” once all the child statuses are all in “reconcile” and I can’t for the life of me figure out what expression to use.

right now I have this:

AND([Work Order Status]=“Working”,IN(“Reconcile”,[Related Order Items][Status]))

This doesn’t seem to work to ensure ALL order items are in “Reconcile” status.