Auto Number: possible to generate Project IDs in Smartsheet?
Is it possible to generate Project IDs in Smartsheet ? And can these be done using the Auto-Numbers feature ?
I have a master sheet containing a list of all the projects that have been under taken in a specific year. I need to assign Project IDs for each project.
Can one generate auto numbers for specific rows ?
As shown in the picture, I want to assign IDs only for projects that are stand alone (see projects A to E) and children tasks (children of Project F and G).
Help Article Resources
Check out the Formula Handbook template!