Auto generating column values by "Set column Values" is not working

[Darren_Murphy]

What you are trying to do sounds very much like the first use case described in the post below:

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…

Just be aware that the method does not guarantee uniqueness in the case where multiple users submit at the same time.