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#
Here's one idea. You would need to create 2 columns.
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.