Checking Some Children Rows but Not All
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.
Help Article Resources
Check out the Formula Handbook template!