How to combine if/or statements
Hi,
I am trying to create a formula so that if days open is >=4 color turns red, if days open is >=2 color turns yellow or color is otherwise green OR if the resolved column is check the color is green
I am trying to combine the below two formulas but can not seem to get it right.
=IF([Days Open]@row >= 4, "Red", IF([Days Open]@row >= 2, "Yellow", "Green"))
(OR [Resolved@row=1, "Green"])
Thanks for any insight!
Best Answer
-
@Samantha House So, typically a single conditional statement is based on a single condition being true or false. You have two conditions either the Resolved is checked, or it is not. If is not checked, then you want to check the Days open and take some action.
=IF(Resolved@row = 1, "Green", IF([Days Open]@row >= 4, "Red", "Yellow"))
Start with the Resolved and work out like the above. You can ignore the
>=2
option, it is implicit.
Answers
-
@Samantha House So, typically a single conditional statement is based on a single condition being true or false. You have two conditions either the Resolved is checked, or it is not. If is not checked, then you want to check the Days open and take some action.
=IF(Resolved@row = 1, "Green", IF([Days Open]@row >= 4, "Red", "Yellow"))
Start with the Resolved and work out like the above. You can ignore the
>=2
option, it is implicit. -
Thank you!!
-
You are welcome.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!