Register with additional field

I’m thinking you can number them 1, 2, 3, 4 for each team. Then all people numbered 1 will see the same view, but they are on different teams.

Here’s the formula to do it inside the Sheets.

It can also be done in Glide, let’s say you create a relation column of the entered team ID to the whole list of team IDs, do a count rollup, then the “next ID” that will be entered via a set column is count + 1.

1 Like