IF OR IF Returning two different values based on cell input
I have one cell that can have multiple values. I need a formula to return one value if one set of criteria are met, another value if only one of those values is different. I know it's a syntax issue that I'm not quite understanding correctly.
I have the following formula working:
=IF(AND(Priority@row = "1 Urgent", [Update Required]@row = 1, [ECN/PCN Compliant]@row = 0), 1, "")
=IF(AND(Priority@row = "2 High", [Update Required]@row = 1, [ECN/PCN Compliant]@row = 0), 2, "")
Priority is a drop down, Update Required and ECN/PCN compliant are both checkboxes.
I would like them to both be in the same formula with it returning the value 1, 2 or BLANK.
Best Answer
-
Try something like this...
=IF(AND([Update Required]@row = 1, [ECN/PCN Compliant]@row = 0), IF(Priority@row = "1 Urgent", 1, 2))
Answers
-
Try something like this...
=IF(AND([Update Required]@row = 1, [ECN/PCN Compliant]@row = 0), IF(Priority@row = "1 Urgent", 1, 2))
-
Awesome. This is so much simpler than what I was trying to conjure up myself. Thank you, Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!