Countifs with Multiple Criteria and Referencing Another Sheet

Hi! I am trying to create a formula that will count the cell if column X (checkbox type) is checked and comlumn Y has "N "or is blank. I would like it to total on my metric sheet so I can generate a graph off of the data, therefore, the formula will be referencing this information from another sheet.

Hope makes sense!

Thank you!


Best Answer


  • That worked perfectly!! THANK YOU SO MUCH! (And thank you for the explanation and extra resources!) 😊


  • Genevieve P.
    Genevieve P. Employee Admin

    No problem at all! Glad it worked for you 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!