pzupke·EHS规范ialist II·✭✭

@Paul Newcome that did the trick! Yeah, the "Initial ID" column is entered into the sheet via form, but it is based on an auto-generated number on another sheet that we use to link other data. Thank you so much!

Thanks for the response, Paul! I was able to get the first suggestion to work, my only concern is that all of these existing rows are actually just for testing. Ideally it would start over from scratch. I suppose I could put in two dummy rows and hide them for the official release. I'm struggling to get the second…