Checking Some Children Rows but Not All

AmandaV · 04/10/19

Hi everyone,

I'm somewhat new to Smartsheet and I'm still learning about formulas and functions.

I have a parent row and 4 children row. If all 4 children rows are checked, that's great but it's most important that the last 3 are checked in order for the parent row to automatically be checked.

I set up a function. =IF(AND([Residence Life]150 = 1), ([Residence Life]151 = 1), ([Residence Life]152 =1) = 1) but it's not reading the last cell in the function.

Any help is appreciated.

Alejandra · 04/11/19

Hello,

You're likely receiving an error message because the opened and closed parenthesis aren't needed for each AND statement. You're formula should look something like this:

=IF(AND([Residence Life]150 = 1, [Residence Life]151 = 1, [Residence Life]152 =1), 1,0)

Also as you see in the example above, remove the equals sign next to your 1 at the end.

If needed, more information on AND function syntax can be found here: https://help.smartsheet.com/function/and

Checking Some Children Rows but Not All

Comments

Help Article Resources

Categories