Is there a formula that will output the row number, and can be used in a column formula?

Abraham Sanchez

Looking for a formula that can output the row number, and can be used in a column formula, this mean that it can not have row specify nombre on it like [Column Name]$1 as column formula don't allow it.

Jenn Hilber

Hi @Abraham Sanchez,

You need to use the Auto-Number column as a helper column and can then create a Row Number Column. I have created this for our internal users and am happy to share.

Here is a link to the sheet: https://app.smartsheet.com/b/publish?EQBCT=45339b4dd5fe4587bf818dfcd9b6cb8c

You should also be able to download the image with the instructions.

Hope this help solve your challenge!

If this answer has helped you, please Vote Up!

Jenn Hilber

Mark Cronk

Hi @Abraham Sanchez ,

Add a system column with autonumber. Configure it so that it represents a row number. Will that work for you?

Mark

Abraham Sanchez

Thanks Mark for your comment. I tried adding autonumber column, the problem is that it works initially, however if you add a row in the middel, it will give it the latest +1 autonumber, or if you delete the row, then, in both cases, it is no longer the same as the row number.

Jenn Hilber

Hi @Abraham Sanchez,

You need to use the Auto-Number column as a helper column and can then create a Row Number Column. I have created this for our internal users and am happy to share.

Here is a link to the sheet: https://app.smartsheet.com/b/publish?EQBCT=45339b4dd5fe4587bf818dfcd9b6cb8c

You should also be able to download the image with the instructions.

Hope this help solve your challenge!

If this answer has helped you, please Vote Up!

Jenn Hilber

Chizu Hieida

@Jenn Hilber This is AMAZING!!! thank you!!!! :)