How to create a calculated field on a custom form

[HarrietJo]

I am trying to create a calculated field on a custom form which would show: Converted Issue Entry Date - Task Reference Number - Issue Name. The calculation I have so far is: CONCAT(RIGHT(Converted Issue Entry Date,2),"-",LEFT(Reference Number),"-",Name) but it does not seem to work. Would anyone be able to advise on this?

Thank you

[RandyRoberts]

Try this:

CONCAT(RIGHT(Converted Issue Entry Date,2),Reference Number," - ",Converted Issue Name)

[RandyRoberts · Accepted solution]

I forgot the first hyphen separator:

CONCAT(RIGHT(Converted Issue Entry Date,2)," - ",Reference Number," - ",Converted Issue Name)

[HarrietJo]

Yes that worked. Thank you for the help! :)

[HarrietJo]

Hi Randy, I have one more question on this. The issue entry date currently shows as 17/06/21. Do you know if theres anyway that I can remove the slashes? As we want to use this for our internal files as a naming convention however you cannot use '/' in a file name. Thank you!