COUNTIFS metric referencing another sheet with multiple columns and drop down criteria

I need help trying to return a count in a metric sheet be referencing one column that has one of 3 criteria, and an additional column has 1 criteria met. My current formula is:

=COUNTIFS({LRDC Status}, OR(CONTAINS("Acquisitions"@cell), CONTAINS("Construction", @cell), CONTAINS("Implementation",@cell)), COUNTIFS({Target Population}, "Medicaid")))

Any help would be appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!