Parent Level Formula Checkbox
I am working with a sheet where I have multiple parent child relationships. Some rows are a straight parent child but others will have a grandparent/parent/child. In order to run conditional formatting at the top line but not the parent lines in the grandparent situation, I believe I need a checkbox to run the conditional formatting off of instead of my child count column. I will also need to report statuses based on this top parent line. What formula can I write to autopopulate the check box of the top parent line so that I don't have to manually manage this field?
Help Article Resources
Check out the Formula Handbook template!