Formula
I have a series deliverables reference from another sheet (sheet 1). In this sheet (sheet 2) I list those deliverables under an objective and I want to rate the entire objective based on the highest risk in my Symbols (Red being the highest risk, then Yellow, Green, Gray) what would be the formula.
Same thing for the objective checkbox, if one check box is selected the objective is a checkbox.
Best Answers

If I understand you correctly, you want Objective 1 (the parent row) to show Red if even one of its deliverables (children) is Red. If none are Red, then look for Yellow and make it Yellow if you find one, and so on.
You can add this formula to your parent row for the Symbol column in Sheet 2
=IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", "Gray")))
For Objective column (which is a checkbox), you can use this formula in Sheet 2
=IF(COUNTIF(CHILDREN(), 1)>0, 1, 0)
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com

Thank you Aravind! Much appreciated
Answers

If I understand you correctly, you want Objective 1 (the parent row) to show Red if even one of its deliverables (children) is Red. If none are Red, then look for Yellow and make it Yellow if you find one, and so on.
You can add this formula to your parent row for the Symbol column in Sheet 2
=IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", "Gray")))
For Objective column (which is a checkbox), you can use this formula in Sheet 2
=IF(COUNTIF(CHILDREN(), 1)>0, 1, 0)
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com

Thank you Aravind! Much appreciated
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!