COUNTIF Checkbox is NOT checked in a cell under a parent row
Hello!
I am new to Smartsheet and am having a hard time with a formula for counting in the cell [Action Plan Progress]25 if a checkbox with the parent row 34 under sub row 37 (Checkbox38 to Checkbox41) is NOT checked.
I keep getting #UNPARSEABLE
Is there a better way or is COUNTIF the right way to go?
Thanks!!
-Whitney
Answers
-
Hey @Whit.Yas
To call out the Children of row37 directly, you can use this formula to count your open problem statements. I assumed you were only interested in rows where a user changed the problem statement from the instruction text.
=COUNTIFS(CHILDREN(Info37), NOT(CONTAINS("Put Problem Statement Here", @cell)), CHILDREN(Checkbox37), 0)
(This should work for your row 24 formula: =COUNTIFS(CHILDREN(Info37), NOT(CONTAINS("Put Problem Statement Here", @cell)))
With the addition of a helper column, you could make the formula dynamic (not specific to row 37) so that it would find your Problem Statement (or Root Cause Analysis) rows regardless of where they end up. Let me know if you are interested in this approach.
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!