Skip to main content

Getting error while adding formula field as "Formula fields should be configured in the field menu dropdown"

  • May 3, 2022
  • 1 reply
  • 146 views

Getting error while adding formula field as “Formula fields should be configured in the field menu dropdown”. Please find attached video link for the same -

1 reply

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • May 3, 2022

That’s not the error message, those are just instructions. The error message is simply the word #ERROR.

The problem is that Airtable can’t encode a lookup field, because a lookup field is an array instead of a text string.

In your formula, you can force-convert the lookup field into a text string by adding
& ""
after the name of the lookup field (after the closing curly bracket that surrounds the field name).