Checkbox if Date Past Due AND <100% Complete OR In Next 10 Days AND <100% Complete

edited 12/09/19 in Formulas and Functions


I am trying to create a formula that will automatically check a box if a due date is past due AND % Cmplt is not 100% OR due date is in the next 10 days AND % Cmplt is not 100%. Basically, I will pull the checkboxes items into a report for a dashboard to provide visibility into past due items and upcoming items.

Is that possible? 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!