Show Active Child Status in Parent Row
Parent has 26 Children (26 week program). Only one Child row will be active per Parent row. Each Child will have a different task in the 'Status' column(single dropdown list). You will select Complete to close the current Child and activate the next Child selecting a different task in dropdown list. I want to show the current status of the child that is active in the parent row.
Sheet example: Current active Child row status is LOA which should show in Parent cell
Help Article Resources
Check out the Formula Handbook template!