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.
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!