Board specific ability to assign a back-up person if the person assigned is marked ass on Holiday or Sick

I would like the ability to be able to assign a back up within an automation which first checks if the person has been marked off as On Holiday or Sick, and if they have then they notify a designated second person, or group.

It would be better to allow this to notification to not be restricted by private board settings, and for all intents and purposes have the same rights as the person on that item.

The use case for this would be for approvals, where I have an editor who is on holiday, but they are embedded into the automations and notifications which now need to be directed to another editor to approve copy.