Home

Timesheet with multiple conditions - HELP NEEDED

%3CLINGO-SUB%20id%3D%22lingo-sub-757992%22%20slang%3D%22en-US%22%3ETimesheet%20with%20multiple%20conditions%20-%20HELP%20NEEDED%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757992%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20formulas%20that%20will%20help%20me%20to%20perform%20the%20below%3A%3CBR%20%2F%3E-%20Check%20that%20core%20working%20hours%20(Details%20in%20Data%20tab%20-%20Core_Working_Hours%20range)%20are%20covered%20depending%20on%20language(s)%20spoken%20by%20team%20members%20(Details%20in%20Data%20tab%20-%20Languages%20range)%2C%20if%20not%20an%20error%20message%20should%20pop%20up%20when%20a%20team%20member%20is%20trying%20to%20select%20hours%20that%20are%20not%20allowing%20the%20below%20to%20be%20covered.%3C%2FP%3E%3CP%3EDay%20Criteria%3A%3CBR%20%2F%3EIf%20Weekday%20(except%20for%20Friday)%20-%20Core%20Working%20hours%20that%20needs%20to%20be%20covered%20are%2008%3A45%20am%20to%2017%3A00%3CBR%20%2F%3EIf%20Friday%20-%20Core%20Working%20hours%20that%20needs%20to%20be%20covered%20are%2008%3A45%20am%20to%2015%3A45%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELanguages%20Criteria%3A%3CBR%20%2F%3EFor%20French%20speakers%20-%20We%20need%20to%20have%20at%20least%202%20speakers%20on%20the%20day%20with%20core%20working%20hours%20covered%3CBR%20%2F%3EFor%20Italian%2FSpanish%20speakers%20-%20We%20need%20to%20have%20at%20least%201%20speaker%20on%20the%20day%20with%20core%20working%20hours%20covered%3C%2FP%3E%3CP%3EFor%20German%20speakers%20-%20We%20need%20to%20have%20at%20least%201%20speaker%20on%20the%20day%20with%20core%20working%20hours%20covered%3C%2FP%3E%3CP%3ECan%20anybody%20help%20out%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-757992%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Timesheet%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
nathsm
New Contributor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies