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

Options

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

Can i create form to edit existing data
Hi, I am trying to work out if smartsheet is able to create a form to edit existing data , i have a project looking after around 900 stores with constantly moving and updated items within the stores i wanted to know if a i had a specific data source "Store ID number" for example, that when you enter the store ID it pulls…
Net Days showing 36500 no matter the actual dates provided.
I am trying to use the NETDAYS function, but it will only respond with 36500. The result should be like 60. The dates I am trying to count are part of some simple (COLUMN + COLUMN) formula.
Trying to return 3 months prior to Date Column
Hello, I am trying to make a column to return dates 3 month before the date in another column. Essentially going to be notifying teams 3 months before something expires. I have a column for the dates. It is set to "date" and i'm using this formula in a helper column =DATE(YEAR(DATE@row ), MONTH(DATE@row ) - 3, DAY(DATE@row…