Convert formula column to email and use it in email destination automation

Hi.
I use Monday with a PRO subscription (5 users).
I need to use a formula column as email column, to become able to use email notification as destination.
Or use another method, like mirror columns…

Columns:

  • Depertament: STATE
  • Manager Name: FORMULA (get by “if” conditions on STATE)
  • Manager Mail: FORMULA (get by “if” conditions on STATE)

Screenshot 2023-05-03 130946

How can i reach this goal?
Thank you and best regards.

Hey there!
You can achieve this with Autoboost!
https://monday.com/marketplace/10000112.

Let me know if you need any help with it :slight_smile:

Hi @dade80vr,

Great news! You can use the VLOOKUP app to help you achieve your goal.
VLOOKUP enables you to connect formula-type columns to other columns within the same board, or even across multiple boards. It’s a useful feature that can make your work easier and more efficient.

Here’s a step-by-step tutorial for mirroring a Monday.com formula column with VLookup.

And if you have any questions or concerns, our support team is always here to help. Just reach out to us at appsupport@jetpackapps.co, and we’ll be more than happy to assist you.

Best,
Cherryl