If and Question for At Risk Flags

Zach Henderson

How do I make this work (combine into a single statement)?

=IF(ISBLANK([Days Overdue]@row), 0, 1)

AND

=IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1), 1, 0)

New to smartsheets! Thank you.

Gia Thinh

Try this

=IF(OR(Days Overdue]@row <> "", AND([Days Overdue]@row > -5, [% Complete]@row < 1)), 1, 0)

Zach Henderson

When I just use this:

=IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1), 1, 0)

Everything looks good. I want to clear the flag if days overdue is "".

When I add this =IF([Days Overdue]@row <> "", 1, 0)

to the function

such as:

=IF(OR([Days Overdue]@row <> "", AND([Days Overdue]@row > -5, [% Complete]@row < 1)), 1, 0)

I then see this:

I want to clear those flags if days overdue = "". Thank you!

Gia Thinh

Try this:

=IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1)), 1, IF([Days Overdue]@row = "", 0, 1))

Gia Thinh

@Zach Henderson,

Try this also. I think it better:

= IF([Days Overdue]@row = "", 0, IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1), 1, 0))