How to auto populate subtasks from information coming in from a new Form entry
I found the below discussion, but after playing with cell linking, still wasn't able to figure this out. I have a form that marketers will fill out to create a request. After the request is entered, 3 teams need to complete an assessment based on the information provided. right now, I'm coping the request row over to the assessment sheet and then adding the children rows that are the tasks. These tasks will never change, so I'm hoping to automate this now very manual process.