Collect values from children rows in multi-select field

Good day

I am trying to collect the children tasks (task 1, 2, 3) in a multi-select column that is called Completed Work. The formula should only collect when the Complete column has been checked. I need some sort of hierarchy formula. See below

Thanks in advance!

Regards,

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!