# Rollup Health

Options
✭✭✭✭

So ... on further thought. Is there a way to add to my existing rollup formula (see below):

=IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green")))

If 5 or more tasks are yellow turn “yellow”

If 3 or more tasks are red turn “red”

91% of my tasks are "Green" so when I only have one "red" and it turns the overall project “red” it isn’t a clear picture of health.

How would I edit my current formula to do that?

Any ideas?

Thanks!

• ✭✭✭✭✭✭
Options

=IF(COUNTIFS(CHILDREN(), "Red") >= 3, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= 5, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green")))

• ✭✭✭✭
Options

@ChristianCo. Thanks for responding! However when I use that formula it returns blank. No red, yellow, or green. What do you think?

• ✭✭✭✭✭✭
Options

You will need to be more specific in your criteria. What is supposed to happen if there are less than 3 reds or less than 5 yellows but they are not all green?

• ✭✭✭✭
Options

If less than 3 reds, but I have 5 or more yellows, turn yellow

If less than 3 reds but 5 or less yellows, turn green

If more than 3 reds and 5 or more yellow, turn red (red trumps yellow)

If more than 3 reds and 5 or less yellow, turn red

Everything else turn green. So ...

If 5 or more tasks are yellow turn “yellow”

If 3 or more tasks are red turn “red”

• ✭✭✭✭✭✭
edited 10/21/22
Options

=IF(COUNTIFS(CHILDREN(), "Red") >= 3, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= 5, "Yellow", "Green"))

" Everything else turn green"

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!