Checking Some Children Rows but Not All
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.
Comments
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!