Count distinct based on multiple criterion

edited 09/13/23 in Formulas and Functions

Hello, I have a large inventory of assets that are tagged in multiple ways and keep changing. For reporting , I want to pull totals of unique number of assets in a dashboard that have multiple criteria in various columns. I know count can be used with distinct, but I tried countif and countifs that did not work with Distinct. How do I run unique counts of things based on criteria from other adjacent columns?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!