Sequence number that reset if year changes

Question

I need a formula that reset the sequence 001 if year changes

https://docs.google.com/spreadsheets/d/18GgcmPiWNh7R8Uj1xG5wdWK8w-tI8J995-6I8YnalLo/edit?usp=sharing

Answer 1

You could use the following in D3: =text(iferror(if(year(C3)<>year(C2),1,left(D2,3)+1),1),"000")&"-"&right(year(C3),2)

Or if you want the result in column B change D2 to B2 in the formula.