How to create a calculated field on a custom form

Question

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 · Accepted Answer

I forgot the first hyphen separator:CONCAT(RIGHT(Converted Issue Entry Date,2)," - ",Reference Number," - ",Converted Issue Name)

RandyRoberts · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO