Formula Field in Workfront Planning

Question

Hi

I am working on formula field in Workfront Planning . My objective is to display the selected values of connected field (Name : Test Field) in new Formula field separated by a delimiter.

Currently what is happening is when I directly write this formuala: {Test Field}, it displays values in this format.
["ABC","PQR","XYZ"]. So I am assuming this is becoming like an array field.

When I change the formula to Arrayjoin(“”,{ Test Field}, the formula field displays value as below without any delimiter.

ABCPQRXYZ.

Wondering how do I add a separator that will enable to get display of values like ABC, PQR, XYZ

IvanBebek-iX · Accepted Answer

Hi ​@Abka,Per official documentationhttps://experienceleague.adobe.com/en/docs/workfront/using/adobe-workfront-planning/adobe-workfront-planning-fields/formula-fieldsARRAYJOINReturns concatenated string by delimiter.The expression is formatted as follows:ARRAYJOIN(delimiter,array)You defined delimiter to be “” basically and empty string therefore you do not have any delimiter between items try to do something likeARRAYJOIN(“,”,{ Test Field})Please let me know if this helps and works.Best regards,Ivan

kautuk_sahni · Answer

​@IvanBebek-iX​@Madalyn_Destafney​@Sven-iX​@Kurt_JonesTagging you to see if you might want to share any best practices or insights on this topic. Your expertise would be greatly appreciated, thank you!

Sign up

Login with SSO

Login to the community

Login with SSO