Is there an escape character for column names?


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.


  • Genevieve P.
    Genevieve P. Employee Admin

    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:



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!