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:


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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!