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

Is there a formula to update the status based off the % complete?
i.e % Complete is = to 0% then Status should equal not started, if % complete is > 0%, then status should be In Progress, if % complete is = to 100% then the status should equal Complete
Hello! I am trying to make a graph with these dates!
I am using a Grid Sheet and a reference sheet but can not figure out how to get the formula to match. I am using =COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2021, 12, 31))) This is my reference sheet formula =COUNTIFS({OnBoarding Partner Agreements Range 1} [Start Date]:[Start Date],…
Formula for numbering rows based on specific conditions
Hello! I need to create formulas for two columns that number rows based on specific conditions. I have a helper column (Number). First, I want to number rows that: Type is "Focus Group Volunteer" and Internal is "yes." Second, I want to number rows that: Type is "Focus Group Volunteer", Internal is "no", and Patron Type is…