Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Is there a way to export or print row numbers
This would be so very helpful.
Thank you
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
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).
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.
I saw that Paul answered already! That would be my solution as well.
Let me know if I can help with anything else!
Andrée
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!
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!
I'm always happy to help!
Happy to help!
Hey Smart Community, Currently I am working in a project which large registration form with nearly 200 questions with 5 category groups. Q 1 to Q15 is common to all Category Q16 to 49 exclusively for Group 1 Q50 to 79 exclusively for Group 2 Q80 to Q115 exclusively for Group 3 Q116 to Q165 exclusively for Group 4 Q166 to…
Hi everyone, In our project plans, sheet admins are responsible for setting the baseline once the project schedule is finalized. However, this step is occasionally missed, which impacts our schedule variance and reporting. I'm looking for best practices to remind admins to set the baseline via automation Also, is it…
I have a form that others in our organization use to submit projects to my department. How it should work: 1) the form when complete populates a row in the Spreadsheet. 2) automation maps certain fields in the form to a PDF. 3) The new row triggers an email to our department with the PDF attached. This used to work…
