Combining IF, AND, OR Functions

[cfrancis-scofield (Cedar)]

I have tried multiple formula options to try and get the end result but I can’t seem to figure out how to either combine if/and/or together or the does not equal option.

Here is the formula closest to what I am trying to achieve:

IF(AND({Group ID}<>{Group ID},{Status}=“Assigned”,“Update”)

Basically, if these two columns aren’t the same and the status is assigned then tell me to update them.

In this scenario, the <> doesn’t seem to work either.

Can anyone help with this?

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi @Cedar,

First you have 2 open parentheses and 1 close, so it can’t work.

Second this comparison

@cfrancis-scofield

{Group ID}<>{Group ID}

is always false since you’re using twice the same field.

Maybe something like this:

IF(AND({Group ID1}<>{Group ID2},{Status}="Assigned"),"Update")