The ability for Mirror columns to be used in Automations have only recently been added, but its still a limited feature.
There is a simple workaround that I currently use for multiple automations identical to yours! You will need to install the app General Caster from the App Marketplace. It works similar to the formula column except it process outside of Monday and send the results to basic columns. So in this case, you will have the Integration send the email from your Mirror column to a text column of your choice and then you can use the Text column in your automation!
Hope that helps. If you need more info or help to set this up, just let me know!
If you are just casting an email from a Mirrored column to a Text Column, the formula field only needs to consist of the columns General Caster placeholder, no functions required.
Thanks @PolishedGeek for your suggestion I was using Caster but starts o be complecated if many boards and they do not answer emails. So found a good solution vlookup but something is not working, maybe it is not possible.
I have:
board 1: customers
board 2: service requests (linked to board 1 customers)
board 3: offered services (linked to board 2 service requests)
I want in board 2 and 3 the email of the customer (not mirrored because i want to use it in the email item view)
In board 2 it works, but in board 3 it doesnt. I have tried using as source board 1 and 2 but does not work. Maybe board 2 can not be at the same time a source board and a target board?
We sincerely apologise for the delay in responding to this thread! We are working on improving our responsiveness to the community, particularly our feature request process so appreciate your patience in advance!
On that note, as we pull together all the votes associated with this topic, we would love if you can redirect the votes on this thread, to the primary thread (most voted) here: About the Link & Mirror function - As we plan to close this thread so we have we have all the votes in one, and can better prioritise this feature request based upon the total amount of votes