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

Automation: Send to contacts in a cell
I'm building an automation to send a reminder to contacts in a cell but it doesn't let select the cell with a dropdown. Is there a workaround?
Subtract 1 month from the date expire for a task
I have a column that calculates a due date that uses this simple formula: =DATE(YEAR([Date Expired]@row), MONTH([Date Expired]@row) - 1, DAY([Date Expired]@row)) It works great but for some reason returns #INVALID VALUE when the date expired is any day in January. any other month seems to be fine I'm guessing because the…
What happens to sheet workflows when the creator is deactivated?
We have multiple sheets with automation/alert workflows, and the person who created those workflows has left the company. We need to deactivate her account and reassign her license. Will the workflows she built still run? I believe an admin or sheet owner can edit others' workflows, but if we do nothing, will her workflows…