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
May 02, 2022
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 -
May 03, 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).