How to include Count Collect formula with Parent Row Count Formula?


Hey there,

I'm trying to add a 'Count Parent and other rows' formula to my existing count collect formula. See existing formula below.

=COUNT(COLLECT({Row ID}, {Category}, $Label@row))

It is counting specific fields from the intake sheet and placing in a newly created sheet. To update it I want to exclude child rows from the count.

Can anyone help me to do this?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!