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