I put prefixes on my column names to indicate certain things, for example: “[Slack] Notify Finance”
I cannot refer to that column in a formula because it starts with with a special chracter, i.e. [
Can we please fix this.. It’s really annoying
I put prefixes on my column names to indicate certain things, for example: “[Slack] Notify Finance”
I cannot refer to that column in a formula because it starts with with a special chracter, i.e. [
Can we please fix this.. It’s really annoying
the square brackets have a special meaning in the formula language.
they are used to enclose names that contain spaces.
similarly, starting column names with other charactets used for operators like +, -, *, is not advisable, they have special meaning inside formulas.
so i do not think this is a bug, its the way formulas are coded.
i have been able to use special characers at the end of column names to indicate their type, such as #$%¿:;¡ etc
As @Agile_Dynamics mentioned, these characters are used within formula language. You can either add the ad the end or simply use Slack - Notify Finance instead of the one you are currently using.