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
Occasional Visitor

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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies