I am trying to calculate a YEAR_ID by concatenating my current row’s YEAR with a count of how many of those years are in the table, +1 to add to the count.

So if I add 5 rows, and the first 2 are 2017, and the next and 3 are 2018, the Year_ID’s would be 2017_1, 2017_2, 2018_1, 2018_2, and 2018_3.

I just don’t understand how to write the select, list, and count.

=CONCATENATE(TEXT([Year]),"_",(COUNT(SELECT(LIST([Year]…???))+1)

Any help greatly appreciated.