Hi there … I need to write an automation based on the CHECK column in Monday. I want to send out different notifications based on if the check was turned on or off … I have managed to get the status of the check column using a calculation field (CHECK STATUS), and also a number indiction the status (0/1) using a calculation field (CHECK NUMBER) … I also have an empty NUMBERS column waiting to accept a value.
Now I need to make something like …
IF CHECK STATUS IS FALSE …(OR STATUS NUMBER IS 0) … (use what’s most appropriate) THEN PUT THE VALUE OF 0 INTO THE NUMBERS FIELD … ELSE PUT THE NUMBER OF 1 INTO THE NUMBERS FIELD …
I can’t make this work … Hope someone can help
Kind regards Nils
It’s unclear if you are talking about using a checkbox or a status to do what you want. Currently, checkboxes are still relatively unsupported in automations. Unless you are interested in creating a custom process using Make (or similar), I recommend that you use a status column.
With a status column, you can create a custom automation like this:
Hi Jim. I will explain a bit more in depth. If you put the Check column into an calculation you will get TRUE or FALSE, based on if ticked to not. I can also convert this into i.e. numbers using another calculation and an IF statement. So far so good …
And since I cannot use calculations in automations (at least yet) I need a way to move the result of the calculation into a text or number field … that I can use as a qualifier in an automation.