Automation when item created if figure in formula column is over or under a figure

Hi, I know there might be questions about getting automations to work from data in the formula column before but I wanted to ask something specific to see if someone has had this problem and found a fix.

I have a formula column (adding up other formula columns on the board) and I want and automation to move an item when it is created and if it is given a specific number in that formula column.

So, if my formula column shows 10 or below when item created it moves it to another group?

hi @andyoungy

This can’t be done with a monday formula column. The reason is that the outcome of the formula is calculated within your browser / app and the monday backend (where all automations rely on) doesn’t even know the outcome of the formula. The app General Caster can be used to do formulas in the backend.

1 Like