We would love to ability to have a simple “if text contains” formula that could update a status column. For instance: if a text contains “ABC” then update status to “ABC”. This would help us use the color-coding that the status column offers to keep better track of our tasks. I realize this is a pretty simple feature request, but it would help us in many of our processes, especially as our boards grow and we rely more heavily on at-a-glance views of our boards.
Check out this other post, I think it’s what you’re after.
Hello im after the same thing.
@Krishele i have readed this post but its not what @mrdjallen is looking for.
If i understood well, we are talking about controlling a status column value (make it change) from a formula column…
actually the status column only can be changed from an automation, the formula column would be great to control this.
Hey @mrdjallen,
Our developers are in the process of working on custom automations. The ability to build out an automation and conditions from scratch. I will provide feedback to my developers regarding formula support.
Lisa
Thats Fabby news. I have been wanting this facility too. Your automations are great but to be able to do custom automations will be great. That and SUB TASKS. Did l mention SUB TASKS yet :0)
Agreed! Subtasks and Custom automations are a must for my team to continue to use Monday.
@Lisa-monday.com Hi! Any updates on this? Thanks
Alex
@Lisa-monday.com hi ! Do you have any news on:
- Custom automations
- Sub tasks
- AutoId improved column
- File attaching support on internal notifications and external email integrations
- Form designer for notifications and email integrations
- Manually timetracking capabilty
???
+1 to above. I’d like an ETA as well.
This is what @lauralev told me about the Custom Automations ETA:
At the moment, I don’t have an ETA but I do know that it is ready for a soft alpha release where we will get some feedback internally before rolling out a beta version. We do have some other things in the pipeline for automations and integrations that are coming first but my hope is within a few iterations our team will be able to release a beta version
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 to this! We have a budget tracking formula column which works great, and it would be great if when it went below zero it could update a status. Alternatively, conditional formatting would be a good fix too.
I know that @gibo and @rob at Omnidea just finished a Proof of Concept monday.com app that can turn any column into a “formula column” hence you can still use the dynamic result with the automations based on status changes and dates.
their solution is really cool!
Yes, as said by @Thomas-Omnitas, we are now developing a monday.com app which can perform calculations in date and number columns, usable then in automations.
Our app will be available later this month to all customers.
Following this thread and looking to do something similar… based on a Status field, assign a formula field a number (score). Having some issues with the formula though… any insight into what I’m doing wrong?
IF({Sales Stage Formula}=Lead,”3”,IF({Sales Stage Formula}=Qualification,“5”,IF({Sales Stage Formula}=Application/Test/Evaluation,“7”,IF({Sales Stage Formula}=Close,“10”))))
Any help would be much appreciated!!
John
Disregard my above… Monday.com helped out. Here’s the correct formula:
IF({Sales Stage Formula}=“1 - Lead”, “3”, IF({Sales Stage Formula}=“6 - Close”, “10”, IF({Sales Stage Formula}=“2 - Qualification”, “5”, IF({Sales Stage Formula}=“3 - Application/Test/Evaluation”,“7”))))
Happy day!
Hi there @Lisa-monday.com, @ lauraglev and co.,
I’ve just started using Monday.com but I would like to use a formula colum to set a status.
For example My sales % is a forumla column but I would like to set a status next to it, so I can automate some actions?
e.g.
IF Sales% = 25% Set Status Red
IF Sales% = 50% Set Status Amber
IF Sales% = 75% Set Status Green
Is this possible ?
Thanks in advance,
coll…
Hi @CollMTE! Thanks for being part of the community
Using a formula, you are only able to create outputs within the Formula Column. It will not allow you to make adjustments to other columns. You can use text and emojis within your formulas in order to create custom labels in the Formula Column, though, as in the example below:
IF({Number}>=0,“Positive ”,“Negative ”)
Do you think that could work for your use case?