Auto Numbering

kibister · 01/24/24

Hello fairly new to smartsheets and mostly stumbling around. I wanted to create a ticketing system for new IT admin request. I created a form. And then on the sheet that is populated from the form I created a column for "Ticket Number." I wanted to create an automation so that whenever a new row is added to the sheet (which means a new form has been populated) that it would modify the Ticket Number column and auto populate it. But I don't know how to do this. Is there any way to populate ticket numbers automatically so whenever a new row/ticket is entered a ticket is created?

Ric T · 01/25/24

Hi @kibister,

In that column you created for "Ticket Number", double click the column header and change the column type from "Text/number" to #Auto number. This way whenever an form is submitted (a new row is added), it will automatically generate a unique identifier. Smartsheet's resource (https://help.smartsheet.com/articles/1108408-auto-numbering-rows) is very handy if you want to take it to the next step and incorporate dates into your ticket numbers too :)

Cheers,

Ric

Ric T · 01/25/24

Hi @kibister,

In that column you created for "Ticket Number", double click the column header and change the column type from "Text/number" to #Auto number. This way whenever an form is submitted (a new row is added), it will automatically generate a unique identifier. Smartsheet's resource (https://help.smartsheet.com/articles/1108408-auto-numbering-rows) is very handy if you want to take it to the next step and incorporate dates into your ticket numbers too :)

Cheers,

Ric

Daniel Liang · 04/22/24

https://community.smartsheet.com/discussion/comment/415389#Comment_415389

Hi Ric,

What if the auto number beyond the limit? For example: the original setting was 3 digits like 001.

What happen if it breaches to 1000?

Ric T · 04/23/24

Hi @Daniel Liang,

Not to worry, it'll continue auto-numbering (e.g. 1000, 1001, 1002) :)

Cheers,

Ric

Daniel Liang · 04/23/24

https://community.smartsheet.com/discussion/comment/432423#Comment_432423

Perfect! Thank you for your update!😀

Auto Numbering

Best Answer

Answers

Help Article Resources

Categories