Copy Data

Hey Everyone,

is it possible to copy SOME data in a child row to another child row under a different parent?

Example..

My first parent row is the "Master List"

Can i copy the "Leader, Staff and Practice" to each other parent "Month" row but be able to manipulate other data within those other "Months". Id love the Master list of staff to copy through each month but be able to change productivity totals for each staff member.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭

    @ldavenportHAP

    I'm not sure I follow completely what the successful results would be. It looks like you're showing the parent "April" and it's child rows. For "Leader" I'd assume since the Leader column has Leanne all the way down that would be the result. The result for Practice would be TRA. Which of the 7 Staff would a successful result be that a formula would create?