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