Show all Children Health Ball Colors in Parent Cell?

Paul Newcome

@clairehunter I understood what you were trying to do. I was meaning the formula itself that was giving you the error so I could see exactly what needed corrected.

clairehunter

@Paul Newcome

Oh I apologize. I was confused. It seems that the formula =IF(COUNT(CHILDREN()) = 0, IF([B/O]@row = 1, "🔴", IF(Status@row = "In Progress", "🟡", IF(Status@row = "Not Started", "⚫️", IF(Status@row = "Completed", "🟢")))), JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), @cell <> "")))) worked perfectly!

Paul Newcome

Yes. That's what we would have eventually gotten to. I was just hoping to help guide you to there so you could have the knowledge moving forward for other formulas.

clairehunter

@Andrée Starå

Thanks so much!

Andrée Starå

https://community.smartsheet.com/discussion/comment/390105#Comment_390105

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!