Fixed Row Number regardless of the sorting

Baserow Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What do you need help with?

I would like to create a column (call it RowNumber) where the value in its cells will always be a sequential number regardless of the sorting options that I choose. If I use Auto-number, it does start with 1…10 for example. But the moment change the sorting option, the value of RowNumber cells changes with the sorting. Is there any formula to give me this option?

2

Hi,

Unfortunately, it is not possible to automatically change the Auto number of you apply a different sort. But you can change the most left column so that it not shows the row id, but just counts the rows:

image
image310×168 6.62 KB

If you still want to see the Row identifier, you can add a Formula field with the function row_id() to return the unique id of each record.

3

Thanks for the reply. Unfortunately, the API call does not show the Count. It only shows the Row ID. I am actually trying to use Baserow for a solution that I am providing. So far it has been great in every area. This was the only thing that did not work with me. However, it is not a deal breaker. I tried different formulas, none of them worked.