Formula to show Row #

MarianneD617

I want to include a column that includes the sheet row # for each line that can be included in a report. The formula I've found is =row(), yet when I enter it in the sheet, I get an unparseable error. What am I missing?

Thanks

Darren Mullen

@MarianneD617 There is no row() function in Smartsheet. It's not hard to do. I don't have a quick video to paste in here, but if you get my 7 tips document it's actually in there.

smartsheetguru.com/tips

SueinSpain

Not sure of the answer but I never use the row number as this changes as soon as you add a row or sort etc.

As a standard every smartsheet has a field called Unique Ref and this has a different prefix for every smartsheet and I always start at 1.

This number stays with the row regardless of where it moves to in the smartsheet and can be filtered on to find.

e,g,

Not sure if this helps :)

Darren Mullen

@SueinSpain Just an aside. Having the row# displayed where it changes as the rows are sorted is of benefit in some applications. One the other hand, using the auto number on a row is very useful when you need a unique identifier for a row that doesn't change.

Both are useful, but have different applications.

MarianneD617

Thank you both for the assist!

MarianneD617

I set up auto-numbering on the Row ID column.

The formula

=MATCH([Row ID]@row , [Row ID]@row , 0)

gives me the correct value for the first line only and repeats that same value for every line below it.

What am I missing?

Thanks

Andrée Starå

https://community.smartsheet.com/discussion/comment/486755#Comment_486755

Hi,

I hope you're well and safe!

Almost there! It should be like this.

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

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

MarianneD617

Thank you! That solved it for me.

Andrée Starå

https://community.smartsheet.com/discussion/comment/486820#Comment_486820

Excellent!

Happy to help!

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏