Create a Automation toUpdate a items staus when all of the subitems ( connected boards / or mirror columns ) change to “ complete”

What I am after is I have items (jobs) with multiple subitems each being linked via mirror column from a different board , I would like a automation feature what updates the items to change status when all of its subitems “status colours” change to a same staus.

This is not supported to include mirror coloumns