Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

I have a View, and I want the row numbers to start from 1, down to the number of rows in that view.

Hi, first of all, thank you for taking the time to read my post. 

To elaborate my question on the title, here's a scenario:

I have a view (from a slice), and upon looking at that view, I can see that the row numbers are uneven. Take a look at the image below:

7ER0_0-1666775357929.png

Granted, it's only showing items according to the Slice's filter condition, however, I want the row numbers to show this type of counting: 1, 2, 3, 4....., 97, 99, 100. 

0 2 1,300
2 REPLIES 2

So what you're trying to do is to find what position a record is in an list.  Not something that appsheet does out of the box i think.  But maybe this would work as a virtual column, assuming you have them ordered by [_RowNumber]

COUNT(Select(SliceName[KeyColumn],[_RowNumber]<[_ThisRow].[RowNumber]))+1

 Simon@1minManager.com

There is no easy way to provide a sequential numbering of rows based on the view.   The biggest challenge, as you noted with a Slice, is the potential constant changing of row order requiring renumbering due to filtering, deletions, additions and sorting.  IMHO, To build this into the app is not worth the effort nor the lost valuable screen real estate. 

Top Labels in this Space