Using IF, AND functions together.
I am trying to create a formula whereby, if the date in the "Due Date" column is less than today and if the "Approval Completed" column box is unchecked, return 1 or 0.
I need to calculate how many tasks are past the due date.
Unfortunately I am getting errors in my formula, can anyone help.
Help Article Resources
Check out the Formula Handbook template!