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?

  • How is the rota laid out? One column? Or a separate column for each day? Or some other way? – Chris Greenhough Nov 29 at 16:44
  • The question is primarily opinion based as there are several ways to "flag" like using a value, conditional formatting, using a note, a comment and many other. By the other hand the question is unclear and it does't include a brief description of the search/research efforts as is suggested on How to Ask. – Rubén Nov 29 at 16:56
  • Sorry, should have been more specific. The rota is one worksheet per month. The names of each worker are listed down one column, with each date in the month them having its own column. Conditional formatting is possible but in Google Sheets always seems really cumbersome. I tried using Data Validation but there seemed to be too many parameters to allow it to work correctly. There are 5 members of staff that must not all be on the same shift or off for each day. – JMc Nov 30 at 22:04

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.