I am trying to concat country and team to show as Country-Team in the Teams Text Line item as shown below. Since there are formulae in place, country and team cannot be changes to text format. How can it be concatenated in the way I am looking for?
Hi,
I can see the Country and Teams line item is List formatted, so you can use the Name() Function to convert into text for concatenation in Teams Text line item you can use name(Country)&"-"&name(Teams) which will resolve your issue and give the concatenation in Text formatted. Hope it will help you!
Bhumit Jain
Thanks Bhumit, worked!
Only thing, I had to lookup the country display name from the country list as country was a numbered list :)
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context andβ¦
