Include formula columns in automation recipes

Hello, with the new custom automation recipes released i was looking for a way to do logical interactions with numbers column data, formulas and automations, but formula columns are not included.

So i find this automation:

This could be a way to interact with formulas, but this type of columns are not supported.

Please, we need to include formula columns in this and other possible recipes.

Thanks.

Hey @hlopezvc - thanks for this request! This is something that has been shared with our product team previously so I upvoted it with your feedback! Would you mind sharing how you are currently using the formula column? I’d be happy to look into any possible workarounds for you.

I need to set up a vehicle maintenance fleet using kilometers as input values.

COLUMN NUMBER A = KILOMETERS OF REAL VEHICLE
COLUMN NUMBER B = OBJECTIVE VEHICLE KILOMETERS FOR A CERTAIN SERVICE
COLUMN OF FORMULA = B - A (HOW MANY KILOMETERS TO ARRIVE FOR THIS SERVICE)

Things I can’t do with Monday.com (missing recipes)

WHEN A FORMULA / NUMBER (could be either of these two) IS GREATER / EQUAL / LESS THAN THIS FORMULA / NUMBER (could be any) THEN:

  • NOTIFY SOMEONE
  • CHANGE OF STATUS TO XXX

Automations (normal and custom recipes) must support ASAP columns of numbers and formulas to automate actions based on logical operations.

Think for a minute about the only avaliable recipe that supports number columns:

  • A column of numbers will always be a fixed number (at least from Monday.com it cannot be changed with any formula or automation). So, I have a fixed value, and I can only compare it with another fixed value!!! … from all points of view, I can’t find a use for this.

I hope this recipes could be avaliable soon. Thanks!

Hi! @melissav-monday.com, another good thing to include is: “between”, “less than or equal to” and “greater than or equal to” in the recipe. I have a board tracking some numbers and would like to change statuses based on the number in the formula column and some of them are ranges.

Here’s an example from Google Sheets conditional formatting:

1 Like

Hi @melissav-monday.com @Julia-monday.com
there is any news in advance on this feature request?

We need this ASAP, think another uses for example we could validate each column field as required entry and dont change a STATUS BUTTON until de conditions are validated.

Hey @hlopezvc & @natybenitez - these are great use cases! We did recently add the following automation that would enable changes to a status column based on particular values:


At this time, the automation does not work with ranges (only greater than, less than, or equal to), but I definitely see how a defined range and the ability to set multiple conditions would be very useful!

We’ll continue to improve these automations (and add more!) so definitely continue to share your feedback with us :slight_smile:

1 Like

Hi everyone, I just ran into this limitation as well. Trying to create an automation that notifies the owner of an item if no updates have been made in x days. I got the formula to determine number of days passed between last change and the current date and that part works fine. What unfortunately doesn’t work is triggering an automation based on the result of the calculation. The formula column is not available in automations and I haven’t been able to find a workaround.

What’s also missing is a way to manipulate the status of another column based on the result of a formula. Please consider integrating this. It would make automations and board use in general soo much more flexible.

4 Likes

Agreed, should be easy to include, and would be so useful!

1 Like

I agree as well. This is a major limitation. If you can create a formula and get a result, why cant you act on it? PLEASE!!