Create a =COUNTIF Formula for dropdown column that has an IF condition

Question

Hi Smartsheet Team!

I need some assistance developing a formula that is going to count multi item dropdown columns.

I am trying to create a dashboard widget that will count per Resolution Status by rep. Effectively, having a widget that shows Rep name > Resolved & In Progress (two separate counts under the same rep without listing rep name twice).

I've been using

=COUNTIF({Range 5}, HAS(@cell,"Resolved" )) but am having trouble adding the condition of  IF "Assigned To" run COUNTIF sequence.

Darren Mullen · Accepted Answer

@CC_ADSK Try using the COUNTIFS() formula, that allows you to use multiple criteria for counting.  I pretty much just default to COUNTIFS() and don't bother much using COUNTIF since COUNTIFS works for 1 criterion or multiple criteria…