The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I don't think you can do this with a formula and would need an automation for this I'm afraid. Here's how you could set up your Update Record action to grab the email:
