Timesheet with multiple conditions - HELP NEEDED
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.