Flag should turn red whenever over due day is over 30 days and status is not completed

Abiola

Hi everyone,

I have a 'risk' column with flag, it is supposed to turn red whenever status does not indicate 'completed' and 'due day' is already beyond 30days, except if the status was cancelled.

I used the formula below but all the flags turned red automatically, I do not know what I am doing wrong, please help:

What is the best way to use current user guide that everyone responsible for task will only see their task and not concern with others?

=IF(AND([Days to due Date]@row < -30, Status@row <> "Completed"), 1, 0) 

Brett Wyrick

Hey Abiola,

You're so close! You don't need a "-30", you need a positive 30.

Also, if you're wanting to add "Cancelled" in there as a status, here's the formula:

=IF(Status@row = "Cancelled", 0, IF(AND([Days to due Date]@row > 30, Status@row <> "Completed"), 1, 0))

You had stated "Except if the status is cancelled" in bold, so I figured that was important.

Here's what it should look like:

Please let me know if this formula works for you!

Abiola

Hi Brett,

It worked like magic!!

Many thanks!

Abiola

Brett Wyrick

Hey Abiola,

You're so close! You don't need a "-30", you need a positive 30.

Also, if you're wanting to add "Cancelled" in there as a status, here's the formula:

=IF(Status@row = "Cancelled", 0, IF(AND([Days to due Date]@row > 30, Status@row <> "Completed"), 1, 0))

You had stated "Except if the status is cancelled" in bold, so I figured that was important.

Here's what it should look like:

Please let me know if this formula works for you!

Abiola

Hi Brett,

It worked like magic!!

Many thanks!

Abiola

Brett Wyrick

@Abiola 👍👍 Glad to help!