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.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!