# Auto numbering column

Options
✭✭✭

I am trying to do the same autogenerating reference numbers using a column that it is like the project class (What is it?) and the reference date will be the created column date that automatically assigned by system when the item is added.

What i want in column Auto Ref Test that Generate the first Letter of "What is it?" column, in this case is R, after that i need a sequential number starting with 0001 and after the year in column "Created"

I followed the formula some formula that i saw in the forum, not sure if this one is the one but even that is giving me an error.

=LEFT([What is it?]@row + "-" + COUNTIFS([What is it?]\$1:[ What is it?]@row, [What is it?]@row, [Created]\$1:[ Created]@row, YEAR(@cell) = YEAR([Created]@row)) + "-" + RIGHT(YEAR([Created]@row), 2)

If you can recommend a formula to input that help me to create what i am trying i appreciate in advance

Tags:

• ✭✭✭✭✭✭
Options

I believe we have a solution in the other thread you are commenting on.

• ✭✭✭✭✭✭
Options

I believe we have a solution in the other thread you are commenting on.

• ✭✭✭
Options

There were 2 parenthesis missing in the formula, now is working

I leave it here in case somebody needs it as example

=LEFT([What is it?]@row) + "-" + (COUNTIFS([What is it?]\$1:[What is it?]@row, [What is it?]@row, Created\$1:Created@row, YEAR(@cell) = YEAR(Created@row)) + "-" + RIGHT(YEAR(Created@row), 2))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!