Common status: Parent/Children formula

I need a formula in a parent row to return the most common value of its children:

If there are equal or more reds than yellows or greens, the parent status should be red.

If there are equal or more yellows than reds or greens, the parent status should be yellow.

If there are equal or more greens than reds or yellows, the parent status should be green.

Otherwise, the parent status should be blue.

Best Answer

Answers

  • Jana Brits
    Jana Brits ✭✭✭✭

    Hey Debbie

    Thank you so much. This worked!

    Kind regards,

    Jana

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    Excellent! Glad it worked :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!