Hi,
I am trying to find formulas that will help me to perform the below:
- Check that core working hours (Details in Data tab - Core_Working_Hours range) are covered depending on language(s) spoken by team members (Details in Data tab - Languages range), if not an error message should pop up when a team member is trying to select hours that are not allowing the below to be covered.
Day Criteria:
If Weekday (except for Friday) - Core Working hours that needs to be covered are 08:45 am to 17:00
If Friday - Core Working hours that needs to be covered are 08:45 am to 15:45
Languages Criteria:
For French speakers - We need to have at least 2 speakers on the day with core working hours covered
For Italian/Spanish speakers - We need to have at least 1 speaker on the day with core working hours covered
For German speakers - We need to have at least 1 speaker on the day with core working hours covered
Can anybody help out?
Thanks.
