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).


Thank you


Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!