Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How do I show Portfolio and Program names in a custom calculated field?


Level 2

I'm trying to add a field to my custom forms that creates a project name automatically. We include the Portfolio Name and Program Name in our file naming convention, but all I can get is the ID for my calculated form.

The current string is:

CONCAT(Reference Number,"_",Quarter,"_",Portfolio ID,"_",Program ID,"_",Type of Creative)

That gives me an output of this on the custom form:


How do I get it to show the actual name of the portfolio and program instead? I tried the following, which did not work:

CONCAT(Reference Number,"_",Quarter,"_",Portfolio Name,"_",Program Name,"_",Type of Creative)

CONCAT(Reference Number,"_",Quarter,"_",Portfolio.Name,"_",Program.Name,"_",Type of Creative)

CONCAT(Reference Number,"_",Quarter,"_",,"_",,"_",Type of Creative)

CONCAT(Reference Number,"_",Quarter,"_",,"_",,"_",Type of Creative)


Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies


Level 2

Have you tried this:

CONCAT(Reference Number,"_",Quarter,"_",Portfolio,"_",Program,"_",Type of Creative)


Community Advisor

You didn't mention the non-working behavior. Is it possible that you might not be recalculating the calculated field every time you make a change to it? (if so, it would retain the answer to the initial calculation so that no matter what you do it shows the GUID)