Have a issue for it to calculate in a multi drop down tab

Im also having a issue with multiple Drop downs.

From My Metric sheet

=COUNTIFS({DEPT Resources Needed}, CONTAINS("Inventory", {DEPT Resources Needed}))

Collecting data from tear sheet

its not adding up



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!