Get Most Updated Task Status From Child
Seeking what kind of formula to update parent row with the most updated child task status in my situations.
I have 5 status of the task in order; not started, waiting, in progress, completed, cancelled. If sub task 1 is completed, it will take sub task 2 status. if sub task 2 is completed, it will take sub task 3 status. But if sub task 3 status isn't complete, it will take its status in parent row.
Below is attachment that describe my situation.
Notes, there's a discussions similar with my situation but still can't find the appropriate method to solve this. Appreciate for your kindly advise/answer.