I'm wondering if someone can help me in my battle with Google Sheets. I'm creating a rota and I want it to flag if all senior members of staff are either off or all on the same shift (either Early or Late). This is to prevent us being in a situation where there's no one available to open or close the shop.
The multiple terms means that I can't quite figure it out. I've got 5 senior members of staff (all with their own row in the rota) and three possibly shift entries of DO, E and L. If all these staff members have the same entry then I need the rota to flag a warning or prevent me from entering in the same shift as all the rest.
Can anyone help me?