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:
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.
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.
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |