Auto increment count on Column based on values appearing in another column


I am trying to add a formula to Column SSI Ref that will count and increment based on the number of times a number appears on SSI# column. I have completed the SSI Ref column for reference as to what I would like to see.

Thank you


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would need to insert an auto-number column (called "Auto" in this example) with no special formatting required and then a text/number column (called "Row" in this example) with the following column formula:

    =MATCH(Auto@row, Auto:Auto, 0)

    Then you can use this in the SSI Ref column:

    =[SSI #]@row + "-" + COUNTIFS([SSI #]:[SSI #], @cell = [SSI #]@row, Row:Row, @cell <= Row@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!