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

CC_ADSK

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

@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…

Darren Mullen

@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…

CC_ADSK

@Darren Mullen - That worked great! Thank you so much!