Concat Fields for Project name.

[NickSkidmore]

Hello all,
I'm looking for a way to concatenate the project reference number with the 2 digit year from the planned start date and the project name.
Ex. 12345-23 Project Name
I'm sure it can be done with Fusion but I have not worked in it enough to feel comfortable. Additionally, I would need it to check current projects for this naming first before applying it since we have been and are currently adding this manually to some of the projects.

I appreciate any help that can be provided.

[NicholeVargas]

If you are wanting to see this in a column in a project list / report, you would use the following text mode. You can rename the line for displayname= to whatever you want your column to be called. 

displayname=Reference Number - Planned Start Date (Year)
textmode=true
valueexpression=CONCAT({referenceNumber}," - ",RIGHT(YEAR({plannedStartDate}),2))
valueformat=HTML

If you wanted to create this as a calculated custom field, it would look like the following on your project custom form (text format) 

CONCAT({referenceNumber}," - ",RIGHT(YEAR({plannedStartDate}),2))

More information on calculated data expressions here.

Hope that helps!