- Quick Intro (The Problem):
Hi, I run 2 massage spa's in a very touristy town. At certain times of the year, it can get very busy, and the 2 spa's need to work together to communicate which therapists are available, and when.
- What I Need:
Using Google Spreadsheets in Drive, I am after a spreadsheet that can automatically adjust times, putting the nearest available time, to the top of the list, while moving all other relevant data from that row with it. I have attached what I have made so far. I can highlight the columns and select 'Sort Range' every time, but my staff are not native English speakers, so the easier the system, the better for them.
(Please check the screenshot that I have attached for a clearer understanding).
* If there is not a way to achieve this, is there another piece of software that one could recommend to do this type of job? It doesn't even need to be online as the receptionists can call each other over the phone to check availability - it just needs to be able to show clearly who is available and when. When we are busy, it is not easy keeping up with this. It probably all sounds rather pointless to some, but believe me, this could be a real life saver if I can find a simple solution.
Thanks a million!!!
Dan
(On screenshot, Lemongrass Garden 1 has not been edited to put the times into order yet. Lemongrass Garden 2, however, is already edited to put the earliest 'Time Out' to the top. Time Out has a formula of 'Time In + Duration'.)
Bookmarks