I’ve sent 7 emails to Monday and they haven’t gotten back to me, so I’ll try my luck here instead.
I want to use conditional formatting (similar to sheets or excel) but it isn’t available. So let’s say I have col A and col B as numbers, and a Status column.
If B is more than A, update the Status column to “Done”.
This works for normal formula columns where the formula I have is IF({COL A} < {COL B}, "DONE", "NOT DONE")
this works well, but there’s no colors.
If I use a formula column to update another column called “Status” (now we have col A, col B, Formula, and Status), like: IF({COL A} < {COL B}, {STATUS} = "DONE", {STATUS} = "NOT DONE")
With this, I can change the color of the status based on the value…
But I got an error saying: "Status" creates a circular dependency.
Hey @zack thanks for writing in here! Sorry to hear you’re having trouble getting in touch with our team - can you check your spam folder for our responses? We also often see that sometimes security restrictions can block emails from coming through – can you whitelist the following emails?
As for the status / formula, @hlopezvc is correct. At this time, there is no way to change a status via the use of an formula, though I will pass this along!
Also, custom automations should be coming soon! Keep an eye out
Hey @cfraticelli our goal is for sometime in the early new year (q 1) but it is going to be a very basic release at first (the automations will be simple) and grow from there!
I also would like to see flexibility for formula fields to modify a status column. In my use case, I am checking 7 different components within a pulse to ensure they contain expected values. If all 7 are completed, then I want to set the status to done. If one or more of the 7 are not complete, then I want to set the status to an in progress state.
I know custom automations is now active. You can adjust status’ based on a column changing. This only kindof works. If the column changes then you can change a status field to something. What I need and I think this thread is talking about is the ability to change a status column based on the results of a formula. Many integrations (Zendesk, Trello, Zoom, Jot Form (to name a few)) bring in the values as text. We need to then be able to “trigger” Monday.com workflows from changes to those values. This is currently not possible (without API and custom code/services). When I have a field in Trello (or any of those previously mentioned integrations) change in value I would like to be able to change a status column to reflect. If the field that comes in changes from red to green to blue, to orange I would like to evaluate the change and change a status column accordingly thus triggering some of the great workflow possibilities available in Monday.com. The current implementation of custom automations fall just short here. The only thing I would be able to do as the text field changes is have a status column change to a single result. Not very helpful.
