Copy formula result to other columns and trigger automations

Hi,

It’s more expensive than that, but I took a look at it for someone else. It does do a good job, but I’m trying to not be reliant on an app for this.

Occasionally, with the correct wording, I can get monday AI blocks to do what I am asking, but I don’t trust AI as well. :laughing:

@DavidSchenkler You’re right that if the formula has any basis on mirror columns, the current approach breaks down. Even worse, if the formula has a basis on a formula that has a basis on a mirror column, it just doesn’t work. And to top it off, AI can’t be completely reliable in these complex scenarios :sweat_smile:.

However this is an issue Formula Pro completely addresses, it’s able to read values from formula columns regardless of how complex the dependencies are. So formulas that use mirror columns that mirror a subitem formula column that has a basis on another mirror column just works without issues.

So you can project that value to a normal column (like text, long text, number etc) to use in automations, emails etc.

Watch these videos to see it in action:

  1. Project formula column value with subitem mirror dependency to normal column
  2. Project formula column with mirror column to normal column

You can check out Formula Pro using this link.

Let me know if it helps.

cc: @RossAtl

1 Like

Hi @hellotimi

I have installed your app to do the following.

We have integrated Salesforce opportunities with Monday.com. An integration automatically creates items on a board when new opportunities are created in salesforce, one of the columns that comes from salesforce is “opp number”.

What I am trying to acheive is that each time a sub item is created under the item, the content of the “opp number” is added to a column in the sub items called “opp number”

I have been unable to get it working with your app as it keeps producing “[object Object]” in the subitem field.

Please help.

Hi @jacquigraham ,

I just sent you a DM.

@jacquigraham To achieve that result, you can try to use either of these recipes from Formula Pro. Let me know if they help.