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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!