Counting Parents on a sheet ignorning children.
Options
Comments
-
You could create a column "Children Counter" with the formula =COUNT(CHILDREN(Task1)), incrementally, in each line.
All the parents will have a value greater than zero.
Then in the cell where you want to count, use a formula such as: =COUNTIF([Children Counter]1:[Children Counter]13, >0).
You can also use a flag that turns on if the Children Counter row has a value greater than 0, or use conditional formatting that changes color based on that formula.
Finally, you could also create a report searching for the parent rows if that is helpful.
I tested it and it seems to work.
-
Thank you! that helped.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!