Count of distinct values with error

Hello SmartHeads!

I hope you are doing great!

I have another question regarding formulas.

There are two columns:

"E - Entry Number"

  • Important: values in this column can duplicate

Two:

"#Discrepancy_Helper"

This is a helper column checking whether or not there is an error in the row.


Desired outcome:

I have to calculate count of Distinct Entry Numbers with at least 1 Discrepancy (value "Yes")

I have already calculated distinct count of entry numbers, but I don't know how to end up with desired value.

Do you have any ideas?


Thanks,

Roman

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!