Calculate Supplier Information


I'm stuck with a formula...I am trying to calculate the number of suppliers with open complaints greater than 3. Any ideas?



Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would need to insert a helper column that has this column formula:

    =IF(COUNTIFS([Supplier Name]:[Supplier Name], @cell = [Supplier Name]@row, [Request Status]:[Request Status], @cell = "Open") > 3, 1)

    Then to get how many suppliers have more than 3 open you would use something like this:

    =COUNT(DISTINCT(COLLECT([Supplier Name]:[Supplier Name], [Helper Column]:[Helper Column], @cell = 1)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!