I'm trying to write a formula that will populate the status cell in a parent row based on priority of different statuses in the children's rows. Here is a copy of the formula I have wrote. =IF(HAS(CHILDREN(), "Quoted"), "Quoted", IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started")))
This formula will populate "Quoted" if it is available in one of the children. What I need is for the formula to selected parts order if quoted is not available or if quote and parts ordered are not available the it will return Assembly/Install and if all three are not available then it will leave blank
The different statuses that do work well are "Complete", "Not Started" . The statues I need to prioritize will be as followed "Quoted", Parts Ordered", "Assembly/Install"
Thank you for any help
Help Article Resources
Check out the Formula Handbook template!