Creating Sub-Auto Numbers

bhope51 ✭✭✭
edited 12/09/19 in Formulas and Functions



We are currently using a web form for customers to submit a service request. After the form has been submitted a auto-numbering confirmation is generated and the customer is sent a notification with that confirmation number. When we process the request we often need to split the service request into multiple services with each service requiring multiple drivers for each service. Is there a way to create a sub auto numbering (Children) if we need to split the request into multiple services and different line items for the different drivers? 


I.E. (AUTO NUMBER) Con# CD_02111

(SUB-AUTO NUMBER)                    CD_02111-a

(SUB-AUTO NUMBER)                     CD_02111-b

(SUB-AUTO NUMBER)                     CD_02111-c

(SUB-SUB-AUTO NUMBER)                          CD_02111-c-1

(SUB-SUB-AUTO NUMBER)                           CD_02111-c-2


  • Shaine Greenwood


    We currently don't have this functionality in Smartsheet. When you have a moment, please submit a Product Enhancement Request using the form under Quick links on the right of the community site and let our Product team know that you'd like to see this functionality added.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!