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.


    Hope this helps.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!