Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Automatic checkbox in parent row when children are all checked?
Comments
-
Amy,
I think the only function you can use on check boxes to compare them is equals to.
I solved your question in this link:
https://app.smartsheet.com/b/publish?EQBCT=35cef6f3a0134843a68074a294a182ed
In production you could hide the two columns on the right.
-Brett
-
This is the formula that goes in the checkbox field. I am assuming your Primary column is named "Primary Column" and that we're working in row 1.
=IF(COUNT(CHILDREN([Primary Column]1)) = COUNTIF(CHILDREN(), 1), 1, 0)
-
What ^he^ said.
-
I'm missing something here. I am trying to use this to set the RYG to Red on the Parent level if all the RYG balls at the Children's level is Red else keep the Parent level Green.
This is what I have.
=IF(COUNT(CHILDREN(Availability5)) = COUNTIF(CHILDREN(), "Red"), "Red", "Green")
What am I missing?
-
Jeff - I just pasted your formula into my sheet and it worked as expected. The parent RYG ball is red if all the children are red and the parent RYG ball is green if this condition is not true.
Make sure your CHILDREN() function is referencing the primary column parent cell as that is the most likely column to contain data in each child row.
-
Thanks Travis.
-
Resolved. Just put following formula in parent checkbox.
=IF(COUNTIF(CHILDREN(), 0) > 0, 0, 1) -
Ratka's solution worked for me perfectly. When all of the children checkboxes were checked, the parent became checked, as well.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives