Nested IF/Or/And Formulas
Hi,
I'd like to combine these 2 formulas below but I couldn't. Is anyone please assist me?
My story is:
if column4 and column5 and column6 are bigger than 30, then make column3 green symbol
if one of the column4 or column5 or column6 is between 0 and 30, then make column3 yellow symbol
if one of the column4 or column5 or column6 is <=0 then make column3 red symbol
I've made the formulas below, they are working separately but I couldn't get them combine :
=IF(OR([Column4]@row <= 0; [Column5]@row <= 0; [Column6]@row <= 0); "Red")
➕
=IF(OR([Column4]@row <= 30; [Column5]@row <= 30; [Column6]@row <= 30); "Yellow"; "Green")
Thanks
Best Answer

Hi Burhan,
Try this in your column 3:
=IF(AND([Column4]@row > 30; [Column5]@row > 30; [Column6]@row > 30); "Green"; IF(OR([Column4]@row <= 0; [Column5]@row <= 0; [Column6]@row <= 0); "Red"; "Yellow"))
It translates to:
If ALL of the following are true (columns 4, 5, and 6 are greater than 30), show green. Otherwise,
If ANY of the following are true (either column 4, 5, OR 6 is at or below 0), show red. Otherwise,
Show yellow.
Hope this helps!
Best,
Heather
Answers

Hi Burhan,
Try this in your column 3:
=IF(AND([Column4]@row > 30; [Column5]@row > 30; [Column6]@row > 30); "Green"; IF(OR([Column4]@row <= 0; [Column5]@row <= 0; [Column6]@row <= 0); "Red"; "Yellow"))
It translates to:
If ALL of the following are true (columns 4, 5, and 6 are greater than 30), show green. Otherwise,
If ANY of the following are true (either column 4, 5, OR 6 is at or below 0), show red. Otherwise,
Show yellow.
Hope this helps!
Best,
Heather

Yeap, it worked! Thank you Heather 😊

Happy to help! Have a great week.

but one more question please :)
why it is not working in these formula below, i'just used or formula first and formula last.
=IF(OR([Column4]@row <= 0; [Column5]@row <= 0; [Column6]@row <= 0); "Red"; "Yellow");if(and([Column4]@row>30;[Column5]@row>30;[Column6]@row>30);"Green"))
thanks
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 379 Global Discussions
 209 Industry Talk
 441 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 298 Events
 33 Webinars
 7.3K Forum Archives