Is there a way to export or print row numbers

Is there a way to export or print row numbers

edited 12/09/19 in Using Smartsheet

Is there a way to export or print row numbers

This would be so very helpful.

Thank you

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Angie,

    When you print there is a choice to "Include row numbers" on the right side in the dialog window.

    Would that work?

    Hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Good morning,

     

    In SS there is an option to print row numbers. But there is no option to include them when exporting to Excel. There also is not an option in Excel to print the row numbers (that I could find in print settings).

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You would need to include a column that duplicates the row numbers. I personally usually call it [Row ID]. The formula to duplicate row numbers is...

     

    =COUNT([Column Name]$1:[Column Name]@row)

     

    You would put this in row 1 and dragfill on down. NOTE: The $ used to lock in the row 1 reference at the beginning of the range is necessary for this to work. So is putting this formula in row 1 and dragfilling from there.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    I saw that Paul answered already! That would be my solution as well.

    Let me know if I can help with anything else!

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Thank you both.

     

    Is [Column Name] the same column? I get a circular reference.

    =COUNT([Row ID]$1:[Row ID]@row)

     

    This will be a great formula to put into my arsenal!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    My apologies. You can reference ANY column on the sheet with the only exception being the formula the column is in. 

  • That is absolutely beautiful!

    This is a wonderful workaround and I will be using it a lot.

    I can't thank you enough. Something so simple will save me more work.

    Have a great day!laugh

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    I'm always happy to help!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help! yes

Sign In or Register to comment.