Is it possible to automatically number the rows in a table?

[Emilian_Bem]

Hi! I have a table view, which is a ranking for users, there are user names and the number of points they have. I would like to add one more column that would show which site a given user has.

It now looks like this:

John 22
Emily 19
Bob 15

I wish it looked like this:

1. John 22
2. Emily 19
3. Bob 15

Thank you in advance for your help!

[Steve · Accepted solution]

It’s possible, but not easy.

See also:

Serial Numbers, If You Must Tips & Tricks 💡

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …

[Emilian_Bem]

Thank you for your response! I will get acquainted with this topic.