# Increment + GSheets
**URL:** https://community.glideapps.com/t/increment-gsheets/54653
**Category:** Ask for Help
**Created:** [November 21, 2022, 9:51pm UTC](https://community.glideapps.com/t/increment-gsheets/54653 "2022-11-21T21:51:26Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@jcmaad](https://community.glideapps.com/u/jcmaad)
#### Post date: [November 21, 2022, 9:51pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/1 "2022-11-21T21:51:26Z")
Hi, I have a GSheets with unique number column. When adding a new row through Glide, I would like to increment the unique number by one. Increment Action doesn’t work, is it because its Gsheets?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 21, 2022, 9:54pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/2 "2022-11-21T21:54:30Z")
Do you want to have row numbers? or counter?
---
### Author:  [@jcmaad](https://community.glideapps.com/u/jcmaad)
#### Post date: [November 21, 2022, 9:55pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/3 "2022-11-21T21:55:23Z")
yea
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 21, 2022, 9:57pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/4 "2022-11-21T21:57:35Z")
there are 2 methods for that, add 1 to the max when creating a new row, or universal method to create a rank number… just look @Robert_Petitto tutorial video:
> [@1st\_place\_medal2nd\_place\_medal3rd\_place\_medal Convert Number Score to Rankings in Glide!](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103):
>
> Using a combination of new Glide Plugin Columns, you can now rank items based on a raw value (points, score, scale, etc.) [[Glide: Create a RANKED Leaderboard!] ](https://www.youtube.com/watch?v=QvNTzYx7tvI)
---
### Author:  [@jcmaad](https://community.glideapps.com/u/jcmaad)
#### Post date: [November 21, 2022, 10:02pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/5 "2022-11-21T22:02:08Z")
> [@Uzo](#):
>
> 1 to the max when creating a new row,
thank you. ranked method seems to be overkill. I ended up creating a new Rollup column with max value, then added a new column that adds 1 to the Rollup column. Is that what you meant by add1 to the max?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 21, 2022, 10:03pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/6 "2022-11-21T22:03:26Z")
yes… but this will give you a fixed number… so when you delete or move the row, it will not be a row number anymore
---
### Author:  [@jcmaad](https://community.glideapps.com/u/jcmaad)
#### Post date: [November 21, 2022, 10:05pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/7 "2022-11-21T22:05:29Z")
Yes, i want to a fixed number. Its a SKU number, so I want it to be static. So, it user adds a new product, I want SKU to increment.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 21, 2022, 10:06pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/8 "2022-11-21T22:06:16Z")
then, adding 1 to the max number is the right method for you… you can use row ID for SKU, but it doesn’t look nice 😉
---
### Author:  [@jcmaad](https://community.glideapps.com/u/jcmaad)
#### Post date: [November 21, 2022, 10:21pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/9 "2022-11-21T22:21:52Z")
thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 21, 2022, 11:31pm UTC](https://community.glideapps.com/t/increment-gsheets/54653/10 "2022-11-21T23:31:11Z")
Please be aware that if two users submit a row too close to each other, you might end up with the same SKU.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 22, 2022, 1:24am UTC](https://community.glideapps.com/t/increment-gsheets/54653/11 "2022-11-22T01:24:48Z")
> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> 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…
---
### Author:  [@jcmaad](https://community.glideapps.com/u/jcmaad)
#### Post date: [November 22, 2022, 2:37am UTC](https://community.glideapps.com/t/increment-gsheets/54653/12 "2022-11-22T02:37:01Z")
Thanks, I think it will stick wit my method. It adds only two columns to the database.