Conditional formatting on checkbox column
is there a way to set conditional formatting on a checkbox column so that if the children's rows are checked, the parent row is automatically checked?
Best Answer
-
Here's a tricky one. It's not exactly the way you asked for it to be done but this is what I came up with:
Child Checked column formula:
=JOIN(CHILDREN(Checkmark@row), " ")
Setup an automation:
The parent row in the Checkmark column was able to be checkmarked automatically using this method.
Answers
-
Here's a tricky one. It's not exactly the way you asked for it to be done but this is what I came up with:
Child Checked column formula:
=JOIN(CHILDREN(Checkmark@row), " ")
Setup an automation:
The parent row in the Checkmark column was able to be checkmarked automatically using this method.
-
Thank you so much @Matt C. !!! The only change that I needed to make to make sure that the parent is only checked when all children are checked is to change the condition to "does not contain" false.
Thanks again for your help!
-
Glad that worked. Ya, I wasn't sure if you needed the parent checked if any of the children were checked or if all of them. I'm glad you figured that part out. Have a fantastic day!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives