I need an automated supermarket rota on Google Sheets
- or -
Post a project like this841
£50/hr(approx. $61/hr)
- Posted:
- Proposals: 11
- Remote
- #3272478
- Awarded
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting

5662681511847113472461264463527048825071733684847573552265698522877563754854




Description
Experience Level: Expert
I need to make an automated supermarket employee rota on Google Sheets.
We currently use an automated rota that you can spend all day working on and then it just wipes everything you've done, so we need to come up with something new that actually works.
In attached screenshot 1 you'll see a list of workers' names in the first column, followed by columns of the hours they're rota'd to work each day.
What I need is for someone to automate it so that when I put in people's hours and departments, it will group everyone working in the same department together and colour code it so all departments are a different colour (see screenshot 2)
I don't need the sections at the top of that screenshot, but I do need a colour coded key for the departments.
Is this something you could do, and if so, how many hours would it take?
Thank you.
We currently use an automated rota that you can spend all day working on and then it just wipes everything you've done, so we need to come up with something new that actually works.
In attached screenshot 1 you'll see a list of workers' names in the first column, followed by columns of the hours they're rota'd to work each day.
What I need is for someone to automate it so that when I put in people's hours and departments, it will group everyone working in the same department together and colour code it so all departments are a different colour (see screenshot 2)
I don't need the sections at the top of that screenshot, but I do need a colour coded key for the departments.
Is this something you could do, and if so, how many hours would it take?
Thank you.

Amber K.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
7 Jun 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies