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.
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.
