How to use a formula to show the row # in a cell

Options

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

  • Sherry Fox
    Sherry Fox ✭✭✭✭✭✭
    Options

    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 System Data Analyst

    Del-Air Heating, Air Conditioning, Plumbing and Electrical

    EAP | Mobilizer | Automagician | Superstar | Community Champion

    https://www.linkedin.com/in/sherryfox/

  • Scott Orsey
    Scott Orsey ✭✭✭✭✭
    edited 03/28/24
    Options

    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!

  • Bert Hoffbeck
    Bert Hoffbeck ✭✭✭✭
    Options

    Scott.

    Thank you - your formula works!

    Bert

  • Sherry Fox
    Sherry Fox ✭✭✭✭✭✭
    Options

    @Scott Orsey ,


    That worked great, thanks for the assistance!!!

    Sherry Fox

    Business System Data Analyst

    Del-Air Heating, Air Conditioning, Plumbing and Electrical

    EAP | Mobilizer | Automagician | Superstar | Community Champion

    https://www.linkedin.com/in/sherryfox/

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!