auto number column

Dorota Dunne
Dorota Dunne ✭✭
edited 05/09/24 in Smartsheet Basics

hi, I have an exisitng sheet and I'm trying to add an auto number column. There was an auto number column before but it wasn't working properly so I have delete it. I have the most recent entry at the top of the sheet and I would like the oldest item to be starting at 1 and top item to be the highest number. however, when I add a new column the count starts at the top and when I enter a new row, it's the highest looking like in the attached screen shot. Any ideas how to fix it?