Auto Functions w/ Update Requests
I am trying to figure out if there is a way to 1) automatically add a new child row once someone has completed an update and 2) send out a "report" of updates (children rows) with the update requests so the person who the task is assigned to can see their previous updates.
As of right now I add a new child row (updates) under each parent row (project) and enter the due date for the updates. The automations to collect project updates get sent out based on these due dates which are monthly.
Maybe there is a better way to do this as well. I am open to suggestions. The sheet purpose is to collect project updates monthly from different teams. The columns that can't be seen in the below image are fields for the team leads to update on.