How to display source sheet row number in a report?

Sameer Karkhanis

In the available columns to display in a report, there is no option to show the row number of the record from the source sheet. Is there any alternative way to accomplish this? If not, can Smartsheet team please add this to the feature enhancements?

Use case: I am displaying several tasks from a project plan that are flagged (with some criteria) and want to show which row number in the project plan this task corresponds to.

SK

Paul Newcome

You will need to use a helper column on each sheet. You can either set it as a system generated auto-number type, or a text/number type with a basic formula in it to establish a row number. You would then include that column on your report.

Sameer Karkhanis

Thanks Paul for your response. 

Your suggestion could have been good alternative, but there is no function or formula to just get the current row number. Also the auto number would not work as it will not adjust to the changes in the rows (add/move/delete)

Hopefully Smartsheet just provides row number in a sheet as the system column that users can just choose to display in the reports.

SK

Andrée Starå

Hi,

This might help!

https://community.smartsheet.com/discussion/formula-determine-row-number

https://community.smartsheet.com/discussion/goto-line

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

SK,

 

Andree's below links should help. There are a few different options in those threads. My personal choice is to pick a column that's already on the sheet (any column at all will work), and count the cells that are blank AND the cells that are not blank.

 

=COUNTIFS([Any Column]$1:[Any Column]@row, OR(ISBLANK(@cell), NOT(ISBLANK(@cell))))

.

Putting that in row 1 and dragfilling down will give you a consistent row count. Using the $ to lock in row 1 as the start of your range and then using @row means that the formula will count from the first row down to whatever row it is on.

Sameer Karkhanis

Thanks Andrée and Paul. Formula is good workaround and I will use it in the interim.

@SmartsheetTeam -- Would still prefer to make the row number column available to be selected as one of the columns in the reports columns to display list.

SK

Andrée Starå

@SK

Hi,

Happy to help!

Also, Please submit an Enhancement Request when you have a moment

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!