Is there a Formula to Insert Rows Based on Criteria?
I have 2 sheets, 1 that holds subsets of tasks, and a master sheet where work is assigned. If I want to add a subset of tasks to my master sheet based on criteria in another column, how would I achieve that? So if in my master sheet LP | Legacy Site Landing Page w/o Form is selected from the dropdown, the formula would look at that criteria, find that same criteria in my lookup sheet (sheet 2) and populate the subset of tasks (child tasks) for that criteria. Not sure if I am explaining that right. Images attached. So in Image 1, I want the child tasks in Image 2 to populate as child rows under the parent row named Story.