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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!