Repeating a Formula referencing children rows

Jeana ✭✭✭✭✭✭

So I have a sheet where the parent row is job requested (Nebraska YR 3). On this row I need a formula to display the current status of the children (TASK)for each request (STATUS), based on a date field not being blank (DATE COMPLETED). I have created a formula that does this but when a new request is added to the sheet I'd like it to automatically generate the children (TASK) and the related STATUS formula?

Each request has the same tasks. Right now I'm having to manually add the Children (TASK) for each new request. The request are generated by a form and then added to this sheet.

Is this possible?

Thanks for any help you can offer!


Best Answer