Nested IF using OR - Getting an #INCORRECT ARGUMENT SET message
Hello!
I have a column with a multiple drop down box (Employment Type). Based on the value chosen, I want to fill in the value in another column (Utilization Target). I have the following formula in the Utilization Target cell, and am getting an #Incorrect Argument Set message. Would appreciate any clues as to where the problem is.
There are two drop down values where I want the result to be 'N/A' and then four drop down values where the result should be '85'.
=IF(OR([Employment Type]@row = "Contractor India Billable", [Employment Type]@row = "Contractor USA Billable"), "N/A", IF([Employment Type]@row = "Full Time India Billable", [Employment Type]@row = "Full Time India Non Billable", [Employment Type]@row = "Full Time USA Billable", [Employment Type]@row = "Full Time USA Non Billable"), 85)
Thanks! Barbara
Best Answers
-
You're very close!
Try this formula in the Target Utilization column: =IF(OR([Employment Type]@row = "Full Time India Billable", [Employment Type]@row = "Full Time India Non Billable", [Employment Type]@row = "Full Time USA Billable", [Employment Type]@row = "Full Time USA Non Billable"), 85, "N/A")
Rich Coles
Prodactive | Smartsheet-aligned Platinum partners
Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration
-
Missing OR function/operator after your second IF function.
=IF(OR( [Employment Type]@row = "Contractor India Billable", [Employment Type]@row = "Contractor USA Billable"), "N/A", IF(OR( [Employment Type]@row = "Full Time India Billable", [Employment Type]@row = "Full Time India Non Billable", [Employment Type]@row = "Full Time USA Billable", [Employment Type]@row = "Full Time USA Non Billable"), 85, ""))
...
Answers
-
You're very close!
Try this formula in the Target Utilization column: =IF(OR([Employment Type]@row = "Full Time India Billable", [Employment Type]@row = "Full Time India Non Billable", [Employment Type]@row = "Full Time USA Billable", [Employment Type]@row = "Full Time USA Non Billable"), 85, "N/A")
Rich Coles
Prodactive | Smartsheet-aligned Platinum partners
Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration
-
Missing OR function/operator after your second IF function.
=IF(OR( [Employment Type]@row = "Contractor India Billable", [Employment Type]@row = "Contractor USA Billable"), "N/A", IF(OR( [Employment Type]@row = "Full Time India Billable", [Employment Type]@row = "Full Time India Non Billable", [Employment Type]@row = "Full Time USA Billable", [Employment Type]@row = "Full Time USA Non Billable"), 85, ""))
...
-
@rich Coles - Thanks for the solution - shorter formula! Thanks @heyjay for finding my mistake!
-
Glad we could help!
Rich Coles
Prodactive | Smartsheet-aligned Platinum partners
Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!