Create a =COUNTIF Formula for dropdown column that has an IF condition
![CC_ADSK](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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.
Best 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…
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen - That worked great! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!