I have the below formula in cell A1 to generate sequential event IDs (DS ID). I’m open to an improved version.
When an event is cancelled (e.g. DS-0011), the formula will skip a cell (A13) and the numbering restarts in A14 with DS-0013. I need for that to be DS-0012 instead. Possible?