How to create a unique Project ID that starts with its parent Program ID?

[hellyars]

Hi,

How can I create a unique ID for each Project within a Program within a Portfolio?  

I want the ProjectID to start w/ the ProgramID plus the number of Projects within that Project, always starting with -001 to N (resetting back to -001 for each Project).

Thanks

PortfolioID	ProgramID	ProjectID	Desired ProjectID
6011A	91A	?	91A-001
6011A	91A	?	91A-002
6011A	91A	?	91A-003
6011A	77N	?	77N-001
6011A	77N	?	77N-002
3045G	23DF	?	23DF-01
3045G	34QQ	?	34QQ-01

[AmeliaG · Accepted solution]

Hi @hellyars,

Thanks for your question! I've attached the solution workflow here. Please let me know if you have any questions. 

Best wishes,

Amelia

[hellyars]

Mind blown.  I always forget about that approach.  Thank you!.

[ponraj]

Here is another approach you may like. 

WorkflowResults