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

06/13/18 Edited 12/09/19

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

  • L_123L_123 ✭✭✭✭✭

    " ' ' "

     

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

     

    "''"

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    That's what I would suggest. Changing

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

    to

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

    should do the trick.

    thinkspi.com

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

  • Paul NewcomePaul 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).

    thinkspi.com

Sign In or Register to comment.