Trying to get the number of instances of a value from a column with a dropdown list property
I have a field (column) in my source sheet named [Hub/Site CLLI]@row that I need to find the number of instances contained in a drop down list named {Tinas node_comparison  All CLLIs} in the target sheet. When found I need to count the number of instances of the "NTODAANODE Ticket #" found in the target sheet. This is noted as {Tinas node_comparison  NTODAANODE Ticket #} in the formula.
When I run the function below, I keep getting a count of "0" even though I know that the [Hub/Site CLLI]@row is located in a dropdown list in the target sheet's {Tinas node_comparison  All CLLIs} column.
=SUMIF({Tinas node_comparison  NTODAANODE Ticket #}, CONTAINS([Hub/Site CLLI]@row, {Tinas node_comparison  All CLLIs}))
With the information I provided, can you suggest what I may be doing incorrectly?
Best Answer

I found this article Formula to count the number of instances in a column from a multientry cell — Smartsheet Community and it worked! So, I'm closing this question. Thank you for taking a look. Here's the formula I wound up using.
=COUNTIFS({Tinas node_comparison  All CLLIs}, HAS(UPPER([Hub/Site CLLI]@row), UPPER(@cell)))
Answers

Try using the HAS formulas instead of the CONTAINS formula.

No, the "HAS" didn't work. Still getting 0 counts.

@cabbsman I just reread your formula. We need to adjust the way it is built.
SUMIF, is RANGE to referenece, what the CRITERION is for that range, and then what RANGE to sum from.
Try this...
=SUMIF({Tinas node_comparison  All CLLIs},CONTAINS([Hub/Site CLLI]@row, @cell),{Tinas node_comparison  NTODAANODE Ticket #})

I found this article Formula to count the number of instances in a column from a multientry cell — Smartsheet Community and it worked! So, I'm closing this question. Thank you for taking a look. Here's the formula I wound up using.
=COUNTIFS({Tinas node_comparison  All CLLIs}, HAS(UPPER([Hub/Site CLLI]@row), UPPER(@cell)))

Hi, I'll take a look, thanks.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!