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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!