Dec 30, 2022 02:36 AM
I want to add a formula where I the cell value is equal to the row number.
So when I move the records around, the cell value dynamically changes.
Any suggestions on how I can do this?
Dec 30, 2022 02:46 AM
Hi @hopstack_market ,
I do not think this is possible. The same cell in a record, could have different row number in different Views.
The alternatives could be:
a) Add a Autonumber fields - that gives you a unique "row number" going forward
b) If you have a certain View where you would like to number the cells and nothing else, you could run a script ( or Make automation) to assign numbers only to those rows based on their current order.
Why do you need to have the row number? There might be better ways to identify a record.
I hope it helps!
Feb 14, 2023 12:43 PM
Is there any update on this?
It is a good feature for us. We need to have a couple of rows where the order is adjustable by people outside the organization. They might also delete some records, so we need the numbers to adjust accordingly (With autonumber it keeps counting taking into account the deleted records).
Feb 14, 2023 09:57 PM
@ob67 out of interest, why would you need row number other than existing one?
One row can be on multiple positions in different views based on the filter/sort.
The only way to add actual number in cell would be to have a view specific script, that reads order of rows and inserts the value to a number field.