Two columns are checked then want separate column to show green
If one column is checked and one is not want to show yellow
if both columns are unchecked want to show red.
Best Answer
-
It sounds like you need a nested if statement. It sounds like you already have the symbol column for the colored ball icons. Your function would look something like
=IF(AND([Column 1]@row = 1, [Column 2]@row = 1), "Green", IF(AND([Column 1]@row = 0, [Column 2]@row = 0), "Red", "Yellow"))
This is what it would look like in the sheet
Answers
-
It sounds like you need a nested if statement. It sounds like you already have the symbol column for the colored ball icons. Your function would look something like
=IF(AND([Column 1]@row = 1, [Column 2]@row = 1), "Green", IF(AND([Column 1]@row = 0, [Column 2]@row = 0), "Red", "Yellow"))
This is what it would look like in the sheet
-
THANK YOU!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!