Is there an escape character for column names?

OnRamps JM

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.

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