Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Quotation marks in the output of a calculated field

Avatar

Level 2
 

Does anyone know how to include quotation marks in the output of a calculated field?

 

For instance, I want the field to display: Say "hello".

The text inside the quotation marks will change based on a custom field.

 

Here's what I've tried in my calculation:

CONCAT("Say "",{DE:Greeting},""")

 

This calculation isn't working because Workfront doesn't handle the extra quotation marks properly. Is there a specific value or method to represent quotation marks in the calculation?

 
1 Accepted Solution

Avatar

Correct answer by
Community Advisor

this seems to work:

CONCAT('Say ','"',{DE:Designer Name},'"')

Rafal_Bainie_0-1726215144267.png

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

this seems to work:

CONCAT('Say ','"',{DE:Designer Name},'"')

Rafal_Bainie_0-1726215144267.png

 

Avatar

Level 2

That worked!

 

I had to remove the apostrophes from the names of any custom fields that I wanted to use. But it was a small price to pay.

 

Thank you!