Count distinct based on multiple criterion

Options
Beena
Beena
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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!