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
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
I forgot the first hyphen separator:
CONCAT(RIGHT(Converted Issue Entry Date,2)," - ",Reference Number," - ",Converted Issue Name)
Views
Replies
Total Likes
Try this:
CONCAT(RIGHT(Converted Issue Entry Date,2),Reference Number," - ",Converted Issue Name)
Views
Replies
Total Likes
I forgot the first hyphen separator:
CONCAT(RIGHT(Converted Issue Entry Date,2)," - ",Reference Number," - ",Converted Issue Name)
Views
Replies
Total Likes
Yes that worked. Thank you for the help! :)
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
Views
Likes
Replies