Trying to have a column add 1+1 in each row

[Michael_Zaps]

I am trying to assign a number to each user profile but don’t know how to input an excel ad function like =[previous cell] + 1. Any ideas?

[Uzo]

just use row numbers, you can find a few methods for that in this forum

[Michael_Zaps]

mind sharing one?

[Uzo]

RowID is great. Could REALLY use Row Number

RowID column Lookup to gather all rowIDs as an array Find Element Index column… Should I continue?) [image]

[Darren_Murphy]

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…