Checkbox if Date Past Due AND <100% Complete OR In Next 10 Days AND <100% Complete
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
Check out the Formula Handbook template!