Creating a Rotating Seniority List based on being asked and being accepted.

[Squeak74]

Hello,

I am trying to create a rotating list of workers based on seniority, that would rotate based on the answers to two questions.
1. Were they asked? Y or N
a. If Y, then they would move to the bottom of the list.
b. If N, then they would not move down, but could move up if the person below them were asked.
2. Did they accept? Y or N
a. If Y, then they would move to the bottom of the list.
b. If N, then they would still move to the bottom of the list.

 

[MARK858]

Sortby needs either 365 or 2021

 

[BoilerMan691]

DOH!...switched over to Teams and it works now, thanks for the advice!

 

[BoilerMan691]

Peter and Mark,

I just wanted to thank both of you, with your help I was able to create something that is functional for our needs. I will have to do some further tweaking to make it "idiot" proof as I will not be the only one utilizing this. But I truly appreciate both of your help on this one.

Best,
Jim

 

[Peter_SSs]

You are welcome. Glad we could help. Thanks for the follow-up.