Home

Trying to create an employee document on who is up for a shift assignment based on seniority.

%3CLINGO-SUB%20id%3D%22lingo-sub-769936%22%20slang%3D%22en-US%22%3ETrying%20to%20create%20an%20employee%20document%20on%20who%20is%20up%20for%20a%20shift%20assignment%20based%20on%20seniority.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769936%22%20slang%3D%22en-US%22%3EI%20have%20no%20idea%20where%20to%20start%20with%20this.%20I'm%20looking%20to%20input%20date%20of%20hire%20and%20somehow%20have%20it%20determine%20who%20would%20be%20up%20for%20a%20mandatory%20shift%20assignment%20starting%20at%20the%20bottom.%20The%20kicker%20is%20if%20the%20lowest%20employee%20picked%20up%20a%20shift%20in%20the%20past%20two%20weeks%2C%20they%20are%20exempt%2C%20so%20there%20would%20have%20to%20be%20a%20way%20to%20put%20that%20in%20as%20well.%20Any%20one%20have%20a%20starting%20point%20here%20or%20a%20template%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-769936%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770745%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20create%20an%20employee%20document%20on%20who%20is%20up%20for%20a%20shift%20assignment%20based%20on%20seniority.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380831%22%20target%3D%22_blank%22%3E%40Vince530%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20community%20members%20to%20help%20you%20%2C%20it's%20better%20to%20send%20sample%20data%20in%20Excel%20to%20avoid%20the%20guess%20work.%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Vince530
Occasional Visitor
I have no idea where to start with this. I'm looking to input date of hire and somehow have it determine who would be up for a mandatory shift assignment starting at the bottom. The kicker is if the lowest employee picked up a shift in the past two weeks, they are exempt, so there would have to be a way to put that in as well. Any one have a starting point here or a template?
1 Reply

@Vince530 

For community members to help you , it's better to send sample data in Excel to avoid the guess work.

Nabil Mourad

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies