Hi There … I am trying to make an Automation that changes from one predefined status to another predefined status based on if a specific column has content or not …
any ideas ?
kind regards Nils
Hey @nmalexandersen,
Good question! We don’t have an automation exactly like this at the moment. Is there any chance you could elaborate on the use case on this one?
Have you thought about using an IF formula function to give a formula output if a column is empty?
Nils,
Going off what Talia mentioned, my first thought is a simple two step combination of Formula column and the following automation:
Instead of “greater than” you can change that variable to “equal to”.
BUT
Unfortunately Monday doesn’t currently support the use of the formula column in Automations. So you will need to employ General Caster to send the result of the IF formula to a numbers column before it can be picked up by the formula.
Using an variant of the this formula:
IF({item.text}=“”,1,2)
This will give you a “1” if the field you are watching is blank, and a “2” if not. Then you create two copies of the automation, one for “1” and one for “2” changing the status to your desired settings. Replace {item.text} with the column you want to watch.
Hope this helps! Let me know if you need more info.
1 Like
Having some issue using this against an e-mail column. Anyone have similar challenges?
Hi @BretF 
Welcome to the Community!
Could you try using this formula?
IF({Email}="",1,2)
Just ensure that your email column is called ‘Email’, or update the formula in order to reflect your column naming!
Let us know if that works out for you 
Hey again @BretF
Just wanted to check in and see if this formula worked for you?
Let us know!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.