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?
Solved! Go to Solution.
Views
Replies
Total Likes
this seems to work:
CONCAT('Say ','"',{DE:Designer Name},'"')
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!
Views
Replies
Total Likes