CountIf with Or and And?

Patti Lewis

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!!

Paul Newcome

You will want to try something along the lines of...

=COUNTIFS(Severity:Severity, "Critical", Status:Status, OR(@cell = "Submitted", @cell = "In Progress", @cell = "Released"))

Patti Lewis

Thank you, Paul!! I am really loving SmartSheet....just struggling with formulas. Thank you!!!

Paul Newcome

You will want to try something along the lines of...

=COUNTIFS(Severity:Severity, "Critical", Status:Status, OR(@cell = "Submitted", @cell = "In Progress", @cell = "Released"))

Patti Lewis

Thank you, Paul!! I am really loving SmartSheet....just struggling with formulas. Thank you!!!