Need Formula to Show Brag status in another column as "At Risk" rather than RED
I am trying to make a formula that will take the RAG status showing in front of the project (RED shown above) and have it show on the Overall BRAG Status row above as AT Risk rather than just RED.
Answers

I think you are looking for a formula to use in the parent row that will create a blue dot if any of the child rows have a red dot. Like this:
If so, you need to make the column a symbol column with red, amber, green, and blue options.
Then use this formula to return Blue if the child rows contain Red.
=IF(CONTAINS("Red", CHILDREN()), "Blue")
You probably already have a formula that creates the red dot. You can adapt that to work only on child rows, and use the new formula on the parent rows by counting the children and applying the new formula only if there are more than 0 children, and the existing formula on all other rows.
=IF(COUNT(CHILDREN()) > 0, IF(CONTAINS("Red", CHILDREN()), "Blue"), "existing formula to create red")
If you prefer the words "AT RISK" to a blue dot then change the word "Blue" to "AT RISK" in the formula.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 213 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!