R,Y,G and G - Part 2

Dyon Martin

Hey @Paul Newcome / @Andrée Starå ,

Well if you dont mind helping, i'll ask another question :-) Started a new thread for others that might want to see it as a separate request.

.

In a nutshell, at the parent level, I'd like the "current health" (R, Y, G, Gray) to be the color of the highest risk child (or gray if there is no movement). Priority would be Red then Yellow then Green. Gray if all the children are gray. In other words, check for the Highest risk, if there is one then roll up to and make the the Parent that color.

.

Here is the formula that works great - the only issue is that the Gray isnt incorporated in the formula. Can you help incorporate the gray?

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

Thanks!

Paul Newcome

Here is what I personally would use...

=IF(CONTAINS("Red", CHILDREN()), "Red", IF(CONTAINS("Yellow", CHILDREN()), "Yellow", IF(CONTAINS("Green", CHILDREN()), "Green", IF(COUNTIFS(CHILDREN(), "Gray") = COUNT(CHILDREN()), "Gray"))))

Paul Newcome

Here is what I personally would use...

=IF(CONTAINS("Red", CHILDREN()), "Red", IF(CONTAINS("Yellow", CHILDREN()), "Yellow", IF(CONTAINS("Green", CHILDREN()), "Green", IF(COUNTIFS(CHILDREN(), "Gray") = COUNT(CHILDREN()), "Gray"))))

Dyon Martin

works like a charm @Paul Newcome You rock! thanks for your help.

.

Side question, thought I'd ask you before I put it out to the bigger community. Do you know of a integration with whatever tool (or feature in SmartSheet) that would produce a timeline view instead of the gantt chart? The gantt chart shows things vertically, I'd like to see milestones over a horizontal timeline.

Thanks!

Andrée Starå

Hi @Dyon Martin,

This might help.

https://www.officetimeline.com/online

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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

Paul Newcome

Happy to help! 👍️

As far as the timeline is concerned... I can't speak much to that, but @Andrée Starå usually has pretty good suggestions for 3rd party tools, so I would suspect the link he provided above should be a good start.

Dyon Martin

Thanks @Andrée Starå ! Just took a look at that site and it looks interesting. I'll give it a whirl. Not sure if it directly links to my activity list in smartsheet (does it?), but I see that it can pull from Excel which Smartsheet can export to.

Thanks!

Andrée Starå

@Dyon Martin

Excellent!

Happy to help!

If I remember correctly, you'll import, but it's not synced.

Let me know how it goes!

Dyon Martin

@Andrée Starå It worked well, the import was seemless. It didnt give the exactly timeline functionality but it is a great asset to have in my backpocket

Andrée Starå

@Dyon Martin

Excellent!

Glad to hear that it works!