Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Number property that replicates the 'row number'

98 1
Showing results for 
Search instead for 
Did you mean: 

I want to add a formula where I the cell value is equal to the row number. 

So when I move the records around, the cell value dynamically changes. 

Any suggestions on how I can do this?

1 Reply 1

Hi @hopstack_market ,

I do not think this is possible. The same cell in a record, could have different row number in different Views. 

The alternatives could be:

a) Add a Autonumber fields - that gives you a unique "row number" going forward

b) If you have a certain View where you would like to number the cells and nothing else, you could run a script ( or Make automation) to assign numbers only to those rows based on their current order.

Why do you need to have the row number? There might be better ways to identify a record.


I hope it helps!