How to include double quotes in the output of a text formula

klontok

I am trying to combine several text elements into an image attribution for each row on my sheet. Here's my formula:

="American Society for Microbiology " + Category1 + ". " + Title1 + ", " + SubmitterFirstName1 + " " + SubmitterLastName1 + IF(ISBLANK([Co-creator #1, Name]1), "", ", " + [Co-creator #1, Name]1) + IF(ISBLANK([Co-creator #2, Name]1), "", ", " + [Co-creator #2, Name]1) + IF(ISBLANK([Co-creator #3, Name]1), "", ", " + [Co-creator #3, Name]1) + IF(ISBLANK([Co-creator #4, Name]1), ".", ", " + [Co-creator #4, Name]1 + ".")

My question is, how do I put the title of the piece (which is in bold in the formula above) in quotes in the final string? In Excel, I would use CHAR(34), but that doesn't seem to exist in Smartsheet. I've even tried adding the double quotes in Excel and then pasting it into Smartsheet, but SS strips out the quotes! So annoying.

L_123

" ' ' "

 

Use a double quote two single quotes and another double quote all smashed together so it looks like this

 

"''"

Paul Newcome

That's what I would suggest. Changing

....+ ". " + Title1 + ", "....

to

.... + ". " + "''" + Title1 + "''" + ", "....

should do the trick.

Maricel Medina

You actually add a backslash before the double quote: ="\"" + Title1 + "\""

Paul Newcome

@klontok

CHAR and UNICHAR functions are also now available, so you should be able to follow what you said in your original post of using CHAR(34).