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

Options

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?

Thanks

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!