Formula for counting total of a specific word in a parent column only (not including child)

Newcomer2 ✭✭✭
edited 12/08/23 in Formulas and Functions

Hi everyone,

Is there a formula to count the total rows of a parent row (instead of making a checkbox section for parent row)?

Need help with this the most:

Is there a formula I can use in summary sheet that can help me find the total count in a different sheet for a specific word (Ex: "NC", "FCAR", "total of all the words", etc) in a column (Finding Type) of a parent row (made a separate column for parent row with checkbox)?

Thank you for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!