Countifs: Help with syntax in Countifs Formula with multiple conditions

Debalfa

Hello All, I am trying to return a count when 2 conditions are present from a referenced smartsheet. This is the formula I created according to the guides I can find, but smartsheet says it is unparsable. Can someone let me know what the error is?

=COUNTIFS({Range 3}, "Current", {Range 2}, "Critical")

Andrée Starå

Hi @Debalfa

I hope you're well and safe!

What column types are the ranges referencing?

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Debalfa

Hi Andree,

This is a screen shot of the 3 text fields I am trying to count the various pivots of how many of items in the Severity Column by value are in the Report Status column values various buckets. Thank you in advance for your assistance. The end result should show me # of Resolved items in the High Severity, # of Resolved items in the Medium Severity, etc.

Paul Newcome

Are you able to provide a screenshot of the formula actually in the sheet similar to the screenshot below?

Debalfa

This is a screen shot of the formula I wrote in Smartsheet, but I get an error.

Paul Newcome

Which error exactly are you getting with the above?

Debalfa

I got the formula to work. The issue was the ranges I was referencing were not being updated. I redid the formula and now it looks like it is picking up both criteria. Thank you so much for the help!

Paul Newcome

Glad you were able to get it working.