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 '18 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 '18 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 '18 at 22:04
  • I'm sorry, that I didn't saw your comment earlier. When 2 or more users comments on a question/answer they don't receive a notification of a new comment unless they are mentioned by preceding their username with @ – Rubén May 29 '19 at 13:27
  • Regarding the additional details, if you are still interested on getting an answer, please edit your question to add them to the question itself. – Rubén May 29 '19 at 16:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.