Quotation marks in the output of a calculated field

Question

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?

Rafal_Bainie · Accepted Answer

this seems to work:CONCAT('Say ','"',{DE:Designer Name},'"')

QuinnCullison · Answer

For anyone seeing this answer later, there is another way to do this as Workfront can have issues with Single Quotes in calculated fields.

If you really need to have the quotation marks you can create a single select dropdown with only a single answer available that is the quotation mark ".Then set that as the Default selection and add it to your form.

Or a calculated field with only the calculation of '"'.

Either way you can reference that field in your concat to add the quotation mark in wherever you need it. It's a bit of a hassle but it's reliable as your calculated field gets longer.

I.E.

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded