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?
Number property that replicates the 'row number'
+1
+18Hi @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!
+2Is 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).
+18Is 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).
@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.
+1@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.
Hi @Greg_F ,
I need the same feature.
I'm trying to keep one view as my priority list and other views are sorted in different ways
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.