COUNTIF / Collect formula


Hey guys I am stumped. I am trying to Count the number of cells in my Company column if the company = "the company name" but only if one or more of the cells in Column G:T has the words "Needs Replaced"

Multiple columns in G:T could have the words "Need replaced" But I only need to count the company name once if that makes any since


  • BullandKhmer
    BullandKhmer ✭✭✭✭✭

    Helper Column

    =IF(OR(CONTAINS("Needs Replaced",G@row),CONTAINS("Needs Replaced",H@row) …. ,CONTAINS("Needs Replaced",T@row)),1)

    Metric Sheet

    =COUNTIFS({Company Name},[Company Name]@row, {Helper Column},1)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!