How to pull and display the value of a cell from its children using string types


I'm using a Smartsheet to organize OKRs. I'd like a parent goal to display the worst status of all the projects underneath it (children rows). Meaning if a OKR has 5 projects under it, 3 of which are On Track, 1 At Risk, and 1 Off Track, the OKR should display the Off Track value from the 1 project, since that's worst of the projects' statuses. What's the right type of formula for this, since the values of the projects' status is a string, not a number?

Best Answer


  • worked! Thank you!