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

**URL:** <https://community.glideapps.com/t/trying-to-have-a-column-add-1-1-in-each-row/47072>\
**Category:** Ask for Help\
**Created:** [August 18, 2022, 2:08am UTC](https://community.glideapps.com/t/trying-to-have-a-column-add-1-1-in-each-row/47072 "2022-08-18T02:08:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Zaps](https://avatars.discourse-cdn.com/v4/letter/m/c5a1d2/32.png) [@Michael\_Zaps](https://community.glideapps.com/u/Michael_Zaps)\
**Post date:** [August 18, 2022, 2:08am UTC](https://community.glideapps.com/t/trying-to-have-a-column-add-1-1-in-each-row/47072/1 "2022-08-18T02:08:54Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [August 18, 2022, 2:24am UTC](https://community.glideapps.com/t/trying-to-have-a-column-add-1-1-in-each-row/47072/2 "2022-08-18T02:24:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Michael\_Zaps](https://avatars.discourse-cdn.com/v4/letter/m/c5a1d2/32.png) [@Michael\_Zaps](https://community.glideapps.com/u/Michael_Zaps)\
**Post date:** [August 18, 2022, 2:26am UTC](https://community.glideapps.com/t/trying-to-have-a-column-add-1-1-in-each-row/47072/3 "2022-08-18T02:26:06Z")

</div>

mind sharing one?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [August 18, 2022, 2:29am UTC](https://community.glideapps.com/t/trying-to-have-a-column-add-1-1-in-each-row/47072/4 "2022-08-18T02:29:14Z")

</div>

> [@RowID is great. Could REALLY use Row Number](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/13):
>
> RowID column Lookup to gather all rowIDs as an array Find Element Index column… Should I continue?) [image]

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 18, 2022, 4:02am UTC](https://community.glideapps.com/t/trying-to-have-a-column-add-1-1-in-each-row/47072/5 "2022-08-18T04:02:41Z")

</div>

> [@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…