Auto-populating Job Numbers

SteCoxy
SteCoxy ✭✭✭✭✭✭

I've had a query from one of our Smartsheet users who are looking to generate consecutive numbers when we they are building rows of jobs. I've advised him of the Auto Number/System column type, which would help with this. He then needs for all children rows to be auto generated an asset number. His query is as below:

If we add a row to a sheet of jobs to create a new job, is there a way of smartsheet allocating it a job number?

Then within sub rows if that job has 10 assets/deliverables would there be a way of creating asset numbers?

Eg Job No: 3021Β followed by asset number 3021.1 3021.2 etc

Next job 3121 followed by 3121.1 3121.2

I think this could be possible, perhaps involving a formula and using a separate column but I haven't a clue where to begin! Any ideas would be much appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!