Auto-populating Job Numbers
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.
Help Article Resources
Check out the Formula Handbook template!