# Register with additional field

**URL:** <https://community.glideapps.com/t/register-with-additional-field/24553>\
**Category:** Ask for Help\
**Created:** [March 21, 2021, 12:08pm UTC](https://community.glideapps.com/t/register-with-additional-field/24553 "2021-03-21T12:08:28Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 21, 2021, 11:05pm UTC](https://community.glideapps.com/t/register-with-additional-field/24553/2 "2021-03-21T23:05:16Z")

</div>

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.

> [@Arrayformula for incremental serial number dependent on another column](https://community.glideapps.com/t/arrayformula-for-incremental-serial-number-dependent-on-another-column/7975/2):
>
> Hi Manan, You can try =ARRAYFORMULA(IF(A2:A\<\>"",COUNTIFS(A2:A,A2:A,ROW(A2:A),"\<="&ROW(A2:A)),"")) Explanation: A2:A\<\>"" : To only number the rows that have data in A COUNTIFS: Only consider rows that have the same project name (A2:A, A2:A) and apply a dynamic range containing only from the start of the column to that specific row (ROW(A2:A), \<=&ROW(A2:A) Please try and get back to me if you need more help. [image]

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.

---

_[View the full topic](https://community.glideapps.com/t/register-with-additional-field/24553)._