# If and Question for At Risk Flags

Options
edited 03/12/22

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.

Tags:

• ✭✭✭✭✭✭
Options

Try this

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

Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

• edited 03/12/22
Options

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!

• ✭✭✭✭✭✭
Options

Try this:

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

Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

• ✭✭✭✭✭✭
Options

Try this also. I think it better:

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

Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!