I don’t believe that you can do that with a formula.

But you could do it with an automation. Automations can see the email address embedded within a collaborator field.

Thanks. I’m aware of automations but not what i need in this case. Was hoping there was some way in which to extract the email address. I can get the email address in PowerBI via the Airtable API, it’s a part of the user item (name, id, email address). Would have thought you could get it via a formula in AT as well.

Formula cannot directly extract the email address from a collaborator field. If you know all the names of the collaborators and their email addresses in advance, you can hardcode them into a formula to make the conversion. However, if the user changes names or email addresses, the formula will no longer work. If you add a new user that the formula doesn’t know about, the formula won’t show it.

What do you need the email addresses for?

If this is a one-time extraction, you could use scripting to get the email addresses.

I actually just wanted a one time extraction so that I could create a list (outside of AT) of all our AT users. (name, email address).

Interested to know how to do this with a script, but for the purpose of my need right now, I can actually just adjust my PowerBI data model to extra the email address into my Excel.