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?
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!
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.