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


  • Thank you so much Paul. This is exactly what I need.

    Can you explain further to help me for the next time

    What does " <> 1 mean

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Checkboxes use 1/TRUE for checked and 0/FALSE for unchecked.

    <> 1 simply means "does not equal 1" or is not checked. On rare occasion, I have had issues with using "= 0" or "equal unchecked", so I have just gotten in the habit of using <> 1.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!