How to add a prefix to a project ID
I am trying to create a project ID column that generates a prefix based on the project type. I'd like the numbers to go in sequential order for each project.
Ex: abc001, abc002, def001, abc003, def002
Additionally, I would like for it to only generate a number if another column specifies "New Project."
Any input would be much appreciated!
Help Article Resources
Check out the Formula Handbook template!