Enhancement Request: Allow Row Number retrievable from formula

J. Craig Williams

I thought I had written an enhancement request for this before, but I have no record of it.

I'd like to be able to retrieve the row number (not the ID, the number) using a formula.

Some use cases:

In this thread (https://community.smartsheet.com/discussion/finding-duplicates) Joel talks about having to sort prior to checking for duplicates. If we could reference the row number, then a simple MIN() addition could be used to flag the earliest (assuming new rows entered at the bottom) of the duplicates.

Creating a set of formulas to determine if a row is a successor would be easier and more complete with this functionality.

When linking sheets, I could pass the row number where the data resides to the other sheet (for troubleshooting or categorization)

A simple SystemID column type for row number (not auto-number -- as sorting will change "my row") would likely suffice but if just pulling the row number without displaying it would work easier, I could live with that.

This request has also be posted to the Form

Craig

 

Shaine Greenwood

In the mean time, you'd probably have to create a formula with absolutes:

=$Column$1 + 1

Then sort and check, then undo the sort (if you want the rows back in place). Not sure if this would completely work out as a workaround.

J. Craig Williams

That's what I normally do but ran into a situation with too many add/deleting of rows to make it worthwhile.

Craig