Use result of a formula column as a trigger for automation

I would like to be able to make a calculation using a formula, and when the result is higher than a certain amount, to be able to trigger an automation that creates an item on another board.

For example, my event costs 150.000 and I have 100 participants. I would like that if 150000/100 is bigger than 1000, then it should open an item on another board for special budget approvals.

This is essential and Monday’s competitors have this feature. A real example of how unsophisticated Monday’s software is.

Hi @nathanru

Indeed, it is a common problem in monday.com
We at resynced.io have a temporary workaround for this problem until it is implemented natively in monday.com

Please find a short video about how you can do that with by using Google Sheets formula: https://www.youtube.com/watch?v=f51NaLaeT3I

100% basic functionality that’s required.

My use cases: I have request forms with multiple scoring dimensions (e.g. # of customers, # of teams, systems, products) that are entered by drop-down / multiple choice / number entry… and a formula column that converts these dimensions into a normalized score.

Now, say if that score is less than 3, do nothing; if it’s 4-7, send a notification to one person; if it’s 8-10 send a notification to the requester and 3 other people.

can I build this without using the formula? Yes, I COULD. It would be ridiculously complicated to do so - many many multiple nested IF statements would need to be built to cover the possibilities, vs a very simple statement if we’re using the normalized score.

It seems like this functionality was asked for 6 years ago, and we’re still waiting

Hi Nathan and Mike! Shannon here with the monday team. :waving_hand: We left a new update in the Feature Request thread, below, to provide everyone with an update on the Formula Column and automations.

We really appreciate you both for sticking this out with us! This feature is on the way and we’ll continue to keep everyone updated in the linked thread. Thank you for your continued feedback.