Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Parent completed when any child is complete & parent completed when ALL children complete
Stwillis
✭✭✭
Hello,
I am looking for two formulas.
- I need a formula to check a parent checkbox when any child is also checked. I tried to use a nested descendants formula but I keep getting errors.
When any TestAccount child is checked, I want the TestAccount Parent to be checked so I can then set up automation to copy the parent and child over to a new sheet.
- I need a formula that will change the parent task to complete when all of the child tasks are marked complete. For example, when all child steps are done for technical introduction, I want the parent task of technical introduction to be complete. When all steps for technical introduction & requirements gathering are complete, I want the parent task for execution to be complete.
Appreciate the help!
Stephanie
Answers
-
HI @Stwillis,
For the first one, here is the formula for it: =IF(COUNTIF(CHILDREN(), @cell) > 0, 1)
If it's more than 0 checked, it'll check the parent checkbox.
This is the second formula for if you want the parent row checkbox to check when all children row checkboxes are checked.
=IF(COUNTIFS(CHILDREN(), 1) = COUNT(CHILDREN([Status]@row)), 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!