Prevent ID reassignment if RAID Type changes except for existing row

Question

I am currently using the formula below to auto-create IDs based on the Module, Subworkstream and RAID Type of each item in my sheet. The problem that I am having is that if the RAID type changes, it resets every ID in the list. How do I prevent that from happening? Hoping for some guidance. Thank you!!!

=[HELPER COLUMN: Module Abbreviation]@row  + "-" + [HELPER COLUMN: Sub-Workstream Abbreviation]@row  + "-" + [HELPER COLUMN: RAIDD Type Abbreviation]@row  + COUNTIFS([HELPER COLUMN: Module Abbreviation]:[HELPER COLUMN: Module Abbreviation], @cell  = [HELPER COLUMN: Module Abbreviation]@row , [HELPER COLUMN: RAIDD Type Abbreviation]:[HELPER COLUMN: RAIDD Type Abbreviation], @cell  = [HELPER COLUMN: RAIDD Type Abbreviation]@row , Auto:Auto, @cell  <= Auto@row )

Paul Newcome · Answer

The way I have gotten around this is to just pull the auto-number and not worry about sequential.

=[HELPER COLUMN: Module Abbreviation]@row + "-" + [HELPER COLUMN: Sub-Workstream Abbreviation]@row + "-" + [HELPER COLUMN: RAIDD Type Abbreviation]@row + Auto@row

Philip Robbins · Answer

@J. Earp I don't typically recommend people devise numbering systems that can self-adjust like this and prefer to treat the auto number column as a unique value across all RAID types. Accepting that you won't have sequential numbering of all your RAID item types is the most pragmatic solution.