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

klontok
klontok
edited 12/09/19 in Formulas and Functions

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.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!