Work Scheduling in Google Sheet

Tezu

New Member
Joined
Jul 27, 2020
Messages
1
Office Version
365
Platform
Windows
Hello Gurus,

I need to build a work Scheduling check in a google sheet which will check available working days from another spreadsheet and suggest availability on a particular day. The situation is that there are multiple teams in different countries and the work requestor may request a work to be completed in say 24 hours by multiple teams or only few teams from a list of many. The requestor,s sheet there will be few input cells like Today,s date, Time, Time to deliver the work (say 24 hours) and multiple countries and he will submit this data. The applicable should run in the backend and check the other spreadsheet in which weekoffs and public holiday for different countries will be listed. Based on today + expected delivery date and time, availability of different teams will be checked and if all teams are available, then it will show "Available", if at least one team out of all is not available, it will show "Not Available". I hope I am able to make it clear. Really appreciate some help here.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,102,563
Messages
5,487,583
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top