Hi Thrill Seekers,
I am seeking a way to access the row number of a row in a sheet. I would be very happy if this came in the form of a SmartSheet function (let's call it Row) so that I could create formulas like "=Row()" for the current row number or "=Row()+2" for the number of the row two rows below the current row. Alas, that function does not appear to be implemented in SmartSheet.
I have created a solution that does achieve the outcome, but as you will see it has a speed issue.
Let's assume that:
* we have two columns at our disposal named Column2 and Column3, and
* that Column2 has a value in every row (you probably have such a column in your sheet but if you don't the you can put the formula =1+0 in row 1 of Column 2 and then copy it down to the end of the used rows).
In the first row of Column3 put the formula =COUNT([Column2]$1:[Column2]1) and then copy it down to the end of the used rows.
Column 3 will now contain the row number which can be used in any location where you would have used the function Row().
This solution survives both the addition, the deletion and the copying of rows, provided that SmartSheet's auto-filling meets its contractual commitments.
BUT, this solution becomes slower and slower as the number of rows in the sheet increases (its computation is of "Order n squared" (where n is the number of rows in the sheet). In our context, and probably yours too, this makes this solution unusable.
So, the thrill here is to find a solution that is of "Order n".
Any assistance at all will be most appreciated.
Help Article Resources
Check out the Formula Handbook template!