Parent Status Updated based on Child Status

Hello! I'm sure this is a super simple formula but I can't figure it out. I would like to update the parent row status to say "FILLED" if a child row has a status of "HIRED", otherwise the parent row is "OPEN". I also need to overwrite the status of the parent row if there is any case where the status needs to be "ON HOLD" or "CANCELLED", so I don't think this can be a column formula.

Best Answer

  • Mike Raposo
    Mike Raposo ✭✭✭✭
    Answer ✓

    Hi Nicole!

    Something like this should work for the situation you're describing:

    =IF(HAS(CHILDREN(), "HIRED"), "FILLED", "OPEN")

    Hope this helps! Let me know if you have additional questions!

    Best,

    Mike

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!