Is there anyway to use a formula with a field that has square brackets inside the field name?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I am trying to create a formula but my field has a square bracket inside. When trying to create a formula i get the error "There are extra characters beyond the end of the formula." Is there anyway to use the field name in my formula without changing the name.


the formula looks something like this If([Food[Produce]] ="Apple", "Apple").

Photo of kenneth

kenneth

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,064 Points 20k badge 2x thumb
I think you have to backslash escape the closing bracket in the field name:

 If([Food[Produce\]] ="Apple", "Apple")
Photo of kenneth

kenneth

  • 0 Points
Perfect that worked. Thanks!