Hi! I’d like ask about how to number the items in a slice without skips to produce something like this (shown in descending order):
The formula I’m using for the “No.” is as follows:
The select function counts the number of items ([Word] is in all of the items so I used that but I could have used [Key] or something else) that have a lower row number and adds 1.
This works OK but generally speaking, using select expressions in this way is not considered to be a good practice. What I don’t understand is how to get around it. I could do the same thing on the spreadsheet side but that would create some latency for the user (new items would not be numbered immediately). I could just use the row numbers, but then I would have skips, which I prefer to avoid.
If I want consecutive numbering to be instantaneous and without skips, is my way the best method? It would seem that AppSheet should have some “inexpensive” (at sync time, that is) way of numbering.