Won't Convert to Column Formula
Trying to use a formula for autonumbering that will start over the fill number every year. Formula works well in a cell, but I can't get it to convert to a column formula
=IFERROR(RIGHT(YEAR(Date@row), 2) + RIGHT(COUNTIF(Date1:Date@row, YEAR(@cell) = YEAR(Date@row)) + 10000, 3), "")
Error message comes up that the column formula syntax isn't quite right, see our help article for more information
Any help would be appreciated!
Help Article Resources
Check out the Formula Handbook template!