# How to use ROW() Excel formula

**URL:** <https://community.glideapps.com/t/how-to-use-row-excel-formula/43786>\
**Category:** Ask for Help\
**Created:** [July 1, 2022, 9:31pm UTC](https://community.glideapps.com/t/how-to-use-row-excel-formula/43786 "2022-07-01T21:31:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [July 1, 2022, 9:31pm UTC](https://community.glideapps.com/t/how-to-use-row-excel-formula/43786/1 "2022-07-01T21:31:27Z")

</div>

Any suggestions to use the ROW()

> **[ROW - Google Docs Editors Help](https://support.google.com/docs/answer/3093316?hl=en)**
>
> Returns the row number of a specified cell.
> Sample Usage
> ROW(A9)
> Syntax
> ROW(\[cell\_reference\]) cell\_reference - \[ OPTIONAL - The cell in which the formula is entered by default

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 2, 2022, 1:34am UTC](https://community.glideapps.com/t/how-to-use-row-excel-formula/43786/2 "2022-07-02T01:34:11Z")

</div>

An alternative to get the row number, assuming you want to start from 1:

- Create a rowID column for the table.

- Create a lookup column, pointing to the rowID column above to return an array of rowIDs.

- Use the “find element index” column, use the lookup column as the array, and the rowID column as the value to find. It will return an index for every row starting from 0.

- Use a math column to add 1 to that index column.

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [July 2, 2022, 6:14am UTC](https://community.glideapps.com/t/how-to-use-row-excel-formula/43786/3 "2022-07-02T06:14:43Z")

</div>

Thank you for this workaround it does the job.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 3, 2022, 6:15am UTC](https://community.glideapps.com/t/how-to-use-row-excel-formula/43786/4 "2022-07-03T06:15:37Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.