Formula Needed for Parent to Inherit Child Value

Lauren B
Lauren B ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below.

I use the "No Active Projects" marker to determine whether or not that department title pushes to a dashboard report. Right now, we have to manually remember to change the value when the first child row turns to "In Progress", but it would be nice if a formula could adjust the value based on the child statuses. 


SS Status Formula Example.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!