Hello All, How do I create an auto numbering system based on a value in another column?

The item number used more than one item should have increasing sequence numbering pattern. for example 8540-0001 line one should have seq #1 and on line at used again should have seq # 2.

Best Answer

  • DKazatsky2
    DKazatsky2 ✭✭✭✭✭
    Answer ✓

    Hi @Sunny Singh,

    Give this a try in the 1st row and drag down, you cannot turn this into a column formula. New rows should still continue to have the formula moving forward.

    =COUNTIF([ITEM NUMBER]$1:[ITEM NUMBER #]1, [ITEM NUMBER]@row)

    Hope this helps.

    Dave

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!