Sequential numbers come up in a few situations, and with different requirements. I put together this example to illustrate a couple of the scenarios, with recipes for achieving them:
https://public.getgrist.com/jiNnH5ULBknm/Sequential-Numbers/m/fork
- How to keep sequential numbers that reflect the order rows are displayed in.
- How to calculate sequential numbers within a group (@Parker_Smal 's question)
- How to calculate sequential numbers that should not recalculate (as for check numbers)