Auto number

I created a sheet to track problems that arise on my project. I also created a form that my team can use to enter in those problems. On my sheet you can use the form or manually enter in the issue but for some reason the Auto number feature in my Issue ID column isn't calculating the issues entered correctly. The numbers are at random and have no particular order. Is there a way to fix this? I provided a picture for more context. Here I have three listed twice.


Answers