CountIf with Or and And?


Hi All!

I was hoping for some guidance on formula set up. I'm trying to create a chart of software defects and their severity. I have built a tracking spreadsheet for these items. I would like to count if the issue status is Submitted, In Progress OR Released AND the severity is Critical. I can then replicate this formula to count those with the other severities (High, Medium, Low, Nice to Have).

I'm new to SmartSheet and finding i'm struggling with formula syntax and structure. Thanks for any guidance you can provide!!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!