Check parent task if children tasks have all been checked
I need help to auto complete a parent task if all tasks relating to the parent has been checked?
See pic below. I know you can use IF formula, but would like to use something a bit more automated using ANCESTOR function if possible. So that I can convert the values to a column formula
Assistance will be appreciated!
Help Article Resources
Check out the Formula Handbook template!