Nesting IF/OR Statement(s)
I'd like to combine multiple IF/OR statements so when I update my status column another column will auto update:
When Status is Complete or Received list Full, if not, list Empty; when Status is In Process or Quoted list Quarter, if not, list Empty; when Status is Dispatched or Ordered list Half, if not, list Empty.
Is something like this possible? Or am I going about it in the wrong way.
I believe there is an error w/ the Empty section as it is being referenced multiple times. Do I move this to the end?
Here is what I have thus far:
=IF(OR(Status1 = "Complete", Status1 = "Received"), "Full", "Empty", IF(OR(Status1 = "In Process", Status1 = "Quoted"), "Quarter", "Empty", IF(OR(Status1 = "Dispatched", Status1 = "Ordered"), "Half", "Empty")))
Might I need to do individual nested IF statements?
Any suggestions or resolutions are welcome :)
Answers
-
Hi! When you nest IF statements, you put each IF statement into the "else" (the 'if not') section of the earlier IF statement. In short, you only want to have the "Empty" in the end of the very final IF statement.
Instead of your stated logic: "When Status is Complete or Received list Full, if not, list Empty; when Status is In Process or Quoted list Quarter, if not, list Empty; when Status is Dispatched or Ordered list Half, if not, list Empty."
What you actually want is this logic: "If Status is Complete or Received list Full, otherwise if Status is In Process or Quoted list Quarter, otherwise if Status is Dispatched or Ordered list Half, otherwise list Empty."
So something like this:
=IF(OR(Status1 = "Complete", Status1 = "Received"), "Full", IF(OR(Status1 = "In Process", Status1 = "Quoted"), "Quarter", IF(OR(Status1 = "Dispatched", Status1 = "Ordered"), "Half", "Empty")))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!