If and Question for At Risk Flags

Zach Henderson
Zach Henderson ✭✭✭
edited 03/12/22 in Formulas and Functions

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

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


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

New to smartsheets! Thank you.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!