How to use a formula to show the row # in a cell
I'm exporting a sheet and am trying to show the specific row number for each record.
Do you know if there is a formula (i.e. =row) that will populate a cell in that record row?
Answers
-
Following for this one. I would love this ability. Far too often the auto number gets messed up. I have to work with sheets where people DELETE records (makes me scream).
Sherry Fox
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
-
Hi @Sherry Fox and @Bert Hoffbeck , I've seen several options for doing this in the Community. The one I use is to go ahead and create an Auto Number column. I'll call it RowID. Then create a second column called [Row #] with the column formula:
= MATCH(RowID@row,RowID:RowID,0)
This will return the index (row number) of the RowID that matches the RowID of the current row. If you already have a column that you know will have unique values in it, you can use that instead of RowID and save yourself a column 😀
Good luck!
Be well
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!
-
Scott.
Thank you - your formula works!
Bert
-
Sherry Fox
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
-
@Scott Orsey, you are a Rock Star!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!