Heath Status Symbol - Parent Row Setup


Hey Guys,

Brand new user here trying to understand the correct formula for a simple project health status.

Have new project where all children roll up to one parent row with start date, end date & % complete.

Would like to have a simple Red, Yellow & Green symbol based upon the parent row that shows overall project status based upon the parent Start , End Date & % Complete.

Can anyone help me in understanding how to set this up?

Hope this makes sense.

Thank you in advance !


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!