Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Conditional Formating : Done/Status based on items below it.
I am using a sheet to tract information being sent by candidates. Is it possible to make the Red Dot in the "Done" Category next to "Candidate Name" Turn Green automatically when all lines associated with it are turned to green/done.
I've been trying to get conditional formatting to work but I can't figure out what the formula should be.
Tags:
Comments
-
Ann,
This can not be done with Conditional Formatting.
Here is a formula that will do it:
=IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", "Red")
Hope this helps.
Craig
-
Thanks!
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 433 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives