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.

Checkbox Parent Cell if any Children cells are Checked

Myra

Myra ✭

11/06/17 edited 12/09/19 in Archived 2017 Posts

Hello,

I am looking to use a formula that will check the box of the parent box if any of the children boxes in the same column are checked.

Can anyone help with that?

Thanks

Tags:

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

11/07/17

This:

=COUNTIF(CHILDREN(), 1) > 0

or if you prefer to use IF() statements, then this

=IF(COUNTIF(CHILDREN(), 1) > 0, 1, 0)

Craig

0 · Share on Facebook Share on Twitter
Myra ✭

11/08/17

Thank you! That works perfectly.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

How Do I Illustrate Checklist Data in a Dashboard?
I am making a dashboard widget to show how many items in the implemented mitigations column are checked and how many are not. I understand that I may need to make a report or a sheet summary to do so first. How can I make this happen? Also, at some point, I'd like to show a relation to, if it is implemented, is the…
Multiple Approvers on one Approval Automation?
My sheet has multiple approvers who vary by the row depending on certain criteria. I want to send them all the row approval request at the same time, then when they all click approve the project can move forward. To count when the responses are all in, I am moving the entry to a new sheet and counting the references that…
Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…