Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
470 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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 1

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