=COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) Formula help!
Currently using =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) with check-boxes as a quick look to tell how many deliverables have currently been accounted for. I need to add additional lines under the parent row, but don't want them to count toward the total shown at the top. Is there a way to do this?
Answers
-
Hi @AmandaC
Will there be any defining detail on these additional rules that will allow you to exclude them from the total count?
For example, if these additional rows all say "Test" in a certain cell, you could use a COUNTIF instead of a COUNT as the second half of your formula:
=COUNTIF(CHILDREN(), 1) + " of " + COUNTIF(CHILDREN([Specific Column]@row), <> "Test")
Let me know if that makes sense! I'd be happy to help further but it would be useful to know more about these addition rows and why you want to exclude them.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 206 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!