Is there an escape character for column names?

Options

I have a sheet that was created through a .csv import. One of the column names ends with "(RA", probably because of character limits. However, this is creating a problem with formulas. When writing an IF statement, the open parenthesis was treated as part of the formula, rather than part of the column name, despite being wrapped with [ ]. I tried using the string escape character \, but that didn't change anything.

Is there a way to escape the ( ? I would rather not rename the column because it's part of an automated export from our tech team and it could create inconsistencies elsewhere.

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @OnRamps JM

    Would you be able to post a screen capture of your formula in the sheet? What is the full column name that you're referencing?

    As long as the column name is wrapped [in these], it should exclude the ( from the formula itself and recognize it as part of the column name:

    Thanks!

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!