How can I create a column that always reflects the current row#?
How can I create a column that always reflects the current row#?
I've tried the System Column/Auto-Number, but cannot get the assigned numbers to match the current Row#
Best Answer
-
Hi Jennifer,
Here's one idea. You would need to create 2 columns.
- Auto Row ID
- RankEQ Formula (Converted to Column Formula)
- Formula =RANKEQ([Row ID]@row, [Row ID]:[Row ID], 1)
The auto-row ID will change as rows get added or deleted but you can use the RankEQ formula to reference the row ID and rank sequentially; 1,2,3,…….999
As long as you have the sheet sorted by "Row ID" the RankEq formula works.
Attached is a screenshot of the concept.
Answers
-
Hi Jennifer,
Here's one idea. You would need to create 2 columns.
- Auto Row ID
- RankEQ Formula (Converted to Column Formula)
- Formula =RANKEQ([Row ID]@row, [Row ID]:[Row ID], 1)
The auto-row ID will change as rows get added or deleted but you can use the RankEQ formula to reference the row ID and rank sequentially; 1,2,3,…….999
As long as you have the sheet sorted by "Row ID" the RankEq formula works.
Attached is a screenshot of the concept.
-
Thank You, Joseph for the response. I will give this a try!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives