Automating a Roll up for RYG Symbols for Health
Thank you for your patience, I'm still learning.
I have gone down a rabbit hole trying to figure out how to roll up Health symbols RGY. In my search for help I came across this formula but it's not working. =IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", "Green")))
In the example below I want a formula to automate the Health symbol to roll up to Treasury, another for Trust, and then overall for Finance that would include the last 5 tasks.