When does a column reference need to be in [brackets]?

Mike L.

I'm using a value, Fund1stDigit@row in a formula but it returns as #UNPARSEABLE unless I use brackets,... [Fund1stDigit]@row. I previously only noticed the need to use brackets when there is a space in the column name just wondering why it is needed in this case? Thanks!

Christian Graf

Hi Mike,

It is needed because you are using numbers in your column name. If you use only letters and no spaces it will not require brackets. This might be because it needs to differentiate between column identifiers, and if you are performing a math function.

Hope this helps.

Christian Graf

Hi Mike,

It is needed because you are using numbers in your column name. If you use only letters and no spaces it will not require brackets. This might be because it needs to differentiate between column identifiers, and if you are performing a math function.

Hope this helps.

Andrée Starå

Hi @Mike L.

I hope you're well and safe!

To add to Christian's excellent advice/answer.

The brackets are also needed when there is any special character used in the column name.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Mike L.

Thanks Christian and Andree this helped!