Customize an auto number

Sam.S

I would like to know how to customize an auto number for a Smartsheet that I currently have. I would like to incorporate the Date, Business Unit, and the type of request. For example, (CAL-BU-QC-01022025). I have column created for each data input.

Paul Newcome

Try this:

=[Auto Number]@row + "-" + [Business Unit]@row + "-" + RIGHT("0" + DAY([Submission Date]@row), 2) + RIGHT("0" + MONTH([Submission Date]@row), 2) + RIGHT(YEAR([Submission Date]@row), 2)

kowal

hi @Sam.S,

The best would be creat extra column (helper) that would be a formula column an the formula shall be sth like: =BusinessUnit@row+"-"+TypeofRequest@row+"-"+Date@row+"-"+AutoNumber@row etc. so this one columnw when you summ it all will be unique because of the AutuNumber column.

Hope it helps

Sam.S

Input Formula

=RIGHT([Submission Date]@row, 8) + "-" + [Business Unit]@row + "-" + [Test Request]@row + "-" + COUNTIFS([Auto Number]:[Auto Number], @cell <= [Auto Number]@row)

Output

01/31/25-Shields-TSE-1

Desire Output

CAL-Shields-TSE-013125

FYI

I added CAL to the prefix of the Auto Number

Sam.S

@Paul Newcome can you help me with the above question.

Thank you.

Paul Newcome

Can you provide a screenshot for context?

Sam.S

@Paul Newcome see the above

Paul Newcome

Try this:

=[Auto Number]@row + "-" + [Business Unit]@row + "-" + RIGHT("0" + DAY([Submission Date]@row), 2) + RIGHT("0" + MONTH([Submission Date]@row), 2) + RIGHT(YEAR([Submission Date]@row), 2)

Sam.S

Thank you!

Paul Newcome

Happy to help. 👍️