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

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 -

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).

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.