How to get Row Number in Smart Sheet ?

Mayur_S

How to get Row Number in Smart Sheet ?

jmyzk_cloudsmart_jp

Hi @Mayur_S

The MATCH function is the most typical way to get a row number.

To get row numbers without duplicates, we must choose a column that has unique values.

https://app.smartsheet.com/b/publish?EQBCT=53bd1d196eb94d08a08005eba2bd165e

So, we usually use the Row ID system column, as the uniqueness is guaranteed. As shown in the example above, users sometimes add rows above the existing ones. (Row 5, Row 3)
Therefore, we can not use the Row ID to get the row numbers but use the value with the MATCH function, as follows.

[Row Number (By Row ID)] =MATCH([Row ID]@row, [Row ID]:[Row ID], 0)
[Row Number (By Created)] =MATCH(Created@row, Created:Created, 0)

If, for some reason, you can not use the Created system column*, I sometimes use the Created system column. This column, in most use cases, gives you unique values. However, as rows 7 and 8 above show, if multiple rows are created simultaneously, you will lose the uniqueness and thus can have duplicate row numbers.

(*) If you have copy rows automation, and the destination sheet has a mismatched Created named column, you can not use the Created system column.

https://help.smartsheet.com/articles/2479626-automatically-copy-rows-between-sheets

If a system column or a baseline column has a name that matches a column with a different column type (dropdown, text/number, etc.), you may encounter the following errors:

Rows can’t appear in the destination sheet because a column on the source sheet has the same name as a system column.

Rows can’t appear in the destination sheet because a system column has the same name as a column on the source sheet.

To resolve this, you can either rename one of the columns or change the column type to match the source sheet.