Using COUNTIF and CONTAINS to count the number of times a word is found in a children rows.

Hi I am trying to find a way to count the number of child rows that contain the word "Updated" and have a combined total of the number of rows that contain "Updated" in each of the levels of ancestor rows.

Thus far my formula is: =COUNTIF(DESCENDANTS([Packaging Job]@row), CONTAINS("Updated", DESCENDANTS([Packaging Job]@row)))

Please let me know if you have any suggestions!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!