Using formulas to update status?

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.

How do I fix this?

I think you cant change a status column from a formula column.
I have requested this too. As well as custom automations…

Thanks for your reply. That’s unfortunate to hear. Let me try and find your request and upvote it.

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?

notifications@monday.com
ops@monday.com
support@monday.com

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 :slight_smile:

2 Likes

Is there any timeline when the custom automations will be out? I’ll take something as broad as the beginning or middle of next year.

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!

1 Like

Okay!!! Thank you thank you thank you!!!

You’re very welcome!!