Count If Formula

Options

Hi I am trying to create a formula that counts how many times "short" appears in a column when the column next to it that is "new".


Here is what I tried:

=IFERROR(COUNT(COLLECT(Term:Term, CONTAINS("Short", @cell) AND([Project Type]:[Project Type],(CONTAINS("New", @cell),)))))


=COUNTIF(Term:Term, CONTAINS("Short", @cell) AND([Project Type]:[Project Type],(CONTAINS("New", @cell),)))


NEITHER ARE WORKING.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!