Hello all, I’ve been trying to figure out how to find the next employee but couldn’t. For example, I have start time and end time as it is shown in the screenshot. It’s Joe’s shift as it equals 1 based on If Then Else Column. [image] I would like the app to show who is next? the next one will be…

:thinking:But… Am I wrong or these are fixed shifts? If the end time always coincides with the start time of the next shift, then you could simply relate end time to start time in the same table. In this case, after Steven it would not be anyone’s turn because the relationship would be empty.

How to find next employee?

Ask for Help

Topic		Replies	Views
Create numeric order in glide sheets Ask for Help	27	1637	January 27, 2023
Find the last day of the following month Ask for Help holdmybeer	47	3205	January 17, 2024
Creating a schedule with If Then Else! Ask for Help	11	813	December 9, 2020
Time sheet Ask for Help	1	97	April 6, 2024
Fun with Dates Project Showcase	156	6713	April 19, 2022

How to find next employee?

Related topics