Formula to copy Child data to Parent


I would like to copy the child data to the parent and want to convert it into a column formula. Is it possible for the below scenario?

Also, for the below I want for Parent cell from Child, I tried =MAX(CHILDREN([Close Date (SF)]@row)), can I convert that into a column formula to get all the Parent cells filled automatically.

Thanks in advance



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!