Counting Parent Rows
Good Morning,
I have smartsheet Parent and Child rows. How do I count the parent rows? Also, how do I COUNTIF for parent rows that meet a certain criteria?
Thank you so much for the help!
Answers
-
Hi,
Create a text/number helper column [level] with the formula =Count(ANCESTORS()).
Parent rows will have a value of 0. Use level:level, 0 in your COUNTIFS formula to include parent rows.
To add other criteria your formula will use the syntax::
=COUNTIFS( level:level, 0 , [other range]:[other range], Other criteria)
For help with formula syntax see the link below.
https://help.smartsheet.com/functions
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!