IF Statement

Kim Michael

I am trying to have a flag cell (Tasks Past Due Alert) trigger when other flags are raced in the row.

If there is any of the flag status cells with a flag, I want the Task Past Due Alert to raise a flag. No luck so far with the formula. Any suggestions?

Mathieu PERSICO

Hi Kim,

Try this formula :

=IF(COUNTIFS([Due date 1 FLAG status]1:[Due date 5 FLAG status]1, 1) = 5, 1, 0)

Hope this helps. Have a ggod day,

Mathieu | evolytion.com

Kim Michael

I plugged in your formula and didn't get an error but it did not trigger a flag if there was a flag raised in those cells.