Skip to content
  • Try for free

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Nested IF using OR - Getting an #INCORRECT ARGUMENT SET message

    ✭✭✭
    in Formulas and Functions

    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

    · Share on FacebookShare on Twitter

    Sign in
    Try for free

    Best Answers

    • Community Champion
      Answer ✓

      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")

      image.png

      Rich Coles

      Prodactive | Smartsheet-aligned Platinum partners

      Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭
      Answer ✓

      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, ""))

      ...

      · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      Answer ✓

      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")

      image.png

      Rich Coles

      Prodactive | Smartsheet-aligned Platinum partners

      Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭
      Answer ✓

      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, ""))

      ...

      · Share on FacebookShare on Twitter
    • ✭✭✭

      @rich Coles - Thanks for the solution - shorter formula! Thanks @heyjay for finding my mistake!

      · Share on FacebookShare on Twitter
    • Community Champion

      Glad we could help!

      Rich Coles

      Prodactive | Smartsheet-aligned Platinum partners

      Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration

      · Share on FacebookShare on Twitter

    Sign in
    Try for free

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions