Expand my Community achievements bar.

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!