Given a company name column I want to be able to fill it in by another column (company email) in another line
So for example:
I want to fill in the empty cell by the other line
Hi Ido,
The Advanced Formula Booster can help you with this. It is a 3rd-party app that allows you to create formulas accessing any item in any group or board. The formulas can cast their results to any column (in this case the company email column). It has many unique features (like a 100-line syntax editor, the ability to use variables, to cast to several columns from a single formula).
Demo
Formula Syntax
The syntax used the LOOKUP function which is one of the more than 200 functions provided by the app.
It looks for the company name the user just entered or selected in the list of all the company names in the board ({BoardItems.Company}). If it finds a match, it returns the corresponding email address.
Depending on your use case, the syntax may need to be refined, but that’s the general idea.
Automation
You only need one automation to make it work:
Let me know if you have any question.