How to create a calculated field on a custom form | Community

Solved

How to create a calculated field on a custom form

Forum|Forum|4 years ago
June 10, 2021
1 reply
760 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by RandyRoberts

I forgot the first hyphen separator:

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

Community Advisor

Community Advisor

Try this:

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

Community Advisor

Accepted solution

Community Advisor

I forgot the first hyphen separator:

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

HarrietJoAuthor

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