How to display source sheet row number in a report?

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.

Find more posts tagged with

Reports

Comments

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.

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.

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…