Using IF(AND to mark yes if 3 different columns are true (one ISBLANK and one (NOT(ISBLANK))

Hoping that someone can help me figure out what I am doing wrong in this formula or another way to do this. I want the "D84 OOW w/No complete date" to say "YES" if the "D84 Completed date" is BLANK, AND the "D56 completed date" is NOT BLANK, AND the "D84 window end" is < today [note: D84 window end will be populated when the D56 complete date is entered]



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!