Formulas to create project IDs

We’re struggling to create unique project identity numbers that will mirror through out a project from quote stage to job stage. I’m wondering if formulas can do that? It would need a text prefix that can be determined by client, and a number that can be determined by the date or client number, plus one or two etc if more than one job comes in.

Hi @Juliaedn

Welcome to the community. This can’t be done with the use of formulas. The good news is that there is a marketplace app that does this. It can be found at Apps Marketplace. A version for subitem numbering is also available (marketplace listing under review). More info at: 15|AutoID Subitems - Excellent Team

Hi @Juliaedn :wave:

Welcome to the Community! :wave:

It look like this post here Formulas to create project IDs - #2 by basdebruin might have answered your question, is that correct?

If so, please don’t forget to mark it as the solution so other users can easily find it, and to close this thread :slightly_smiling_face:
If not, feel free to ask any additional questions you have!


Hi again @Juliaedn :smiley:

I hope the answers in this thread are useful!
As we haven’t had any updates here, I’m going to go ahead and mark this thread as solved.
This means that the thread will close in 7 days time :slightly_smiling_face:

If you have any additional questions or you feel your original query wasn’t resolved, please feel free to let us know and we’ll be happy to continue to assist!



This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.