I am sure this question has been answered but I have looked at so many variations that I think I am starting to confuse myself.

I am trying to make a count IF one column shows one thing but then then another column has the word HOLD in it.

So for example, I want to count the lines if Job Type says Burg and then Job Status has the word HOLD in it.

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Peggy P

    You would want to add a Helper Column in the source sheet in order to indicate if the row is a Child Row or a Parent Row. Then you can use this column as another Range with the criteria being if this column indicates if the row is a Child one or not.

    Example formula:

    =IF(COUNT(ANCESTORS([Primary Column]@row)) >= 1, "Child", "Parent")

    ^This says, if the number (count) of Ancestors (Parents) of this current row is greater-than-or-equal-to 1, then return the text "Child". Otherwise, it's a Parent row.

    Does that make sense?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!