At Risk Formula

SofiRuiz Overachievers
edited 06/23/22 in Formulas and Functions


I am trying to put together a formula that flags a project 'at risk' when:

  • Deadline is in 3 working days or les from today
  • Status is not complete, on hold or canceled

This is what I have - but my challenge is getting trying to incorporate 'workdays' to the formula. I've tried several ways and it is not working.

=IF(OR(Status@row = "On hold", Status@row = "Canceled"), 0, IF(AND([Final Deadline]@row <= TODAY(3), Status@row <> "Complete"), 1, 0))

Thanks for your help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!