While it is nice to have a work around identified in the General Caster tool, I believe this should really be a Monday.com native feature given how useful it would be. Even an internal workaround would be great!
How about allowing an automation to copy the value in a formula column cell to a number column cell? Something like when time tracking is updated, copy the value from my time remaining formula to a number column.
Then I could use that number column in automations.
This is just one idea of a work-around. Not ideal, but it would help.
We are also looking for the ability to use automation on a formula column.
We are using the formula column to create an average across the value of various columns. If the average is greater than X, we want it to be able to change a status to âHighâ, If the average is lower than Y, we want it to be able to change a status to âLowâ.
This is also a major use case for a âBetweenâ function for the recipe. In this case we would make it âMediumâ It really should be something that exists in thisâŠ
I am just exploring the use of FORMULAS in Monday.com. I am unable to find âGeneral Casterâ in the Integration offerings. I am wanting a status to change based on how many WORKdays there are until a DATE. I was able to create a formula tallying the number of WORKdays until a DATE, however I am not able to figure out how to create an automation based on this formula. Please advise and bump up this feature request.
I just wanted to bump this thread. This is a feature that our company would benefit from significantly.
More specifically, we are currently building boards on Monday.com which have dates outputted in either (i) formula columns, or (ii) subitem summary columns. Neither of these can currently be used in the formula automations for our intended use: automatically sending emails based on whether a formula-output date is reached.
General Caster does solve this issue relatively well. However, with our data privacy concerns, and the size limitations of the product (GC limited to 500 integrations per month before payment), this is not a viable solution for us. So we are looking forward to having this feature as part of Monday soon.
+1 to requesting formula columns to be included in automations.
My use case for this: I have 2 columns, original time estimate and current time estimate, and a formula column to calculate the % time remaining. I want to set up an automation to alert the item owner when % time remaining drops below a certain threshold. What this requires is an automation âwhen {formula} is below {value}, {notify} {person}â. I can do this for numbers but not formulas.
Iâm also looking for using formula columns in Automations.
However, the only reason I initially wanted to use a formula was thinking I could expand other limitations to automations. So, really allow any column, any value to be used in automations.
What am I missing? For any column besides item, status, person, and date I can only start automations with âWhen column changesâ but canât seem to even specify what the change is, or simple comparison function, etc. I thought I could create a work-around by having another automation change the value of a number column then use the number column value to trigger another automation. But I canât see anywhere how I can even use a number column value to start an automation. I suppose I need to create more dummy status columns for thisâŠ
From what Iâve been able to find/test, General Caster wonât reference Formula Columns any more than Monday does.
What Iâve done is created multiple formula columns that feed off one another and the automation I want to create is based on one of those derived formula columns but neither Monday nor General Caster can reference a Formula Column, so itâs still a problem.
I just want to be able to either use a formula column in Monday native automations or a way to reference a formula column in General Caster or some other integration.
This seems like a no-brainer. When Formula Column value equals âXâ should be a trigger for automations.
Not having this feature causes a LOT of manual work on our end, reviewing multiple columns to determine if an item is ready for the next stage in our workflow, then manually setting Status values.
I really want to use the formula date (final date from the other 3 date columns) into automation for notification!!
Please, anyone from Monday.com team look into this issue and demand ?
To use formula columns for automation is really a basic need.
Without this the possibilities are extremly limited. It seems that this
issue is more than 2 years old and still no solution. Does anybody know
if this is possible with ASANA? In this case it would make sense to switch.