It is clear from your screenshot that the email value you mapped into the “Formula” was empty which is the reason why the Airtable output was empty. You should use a value that has the email address and then it should work just fine.
2 Likes