IF Then [Incorrect Argument] Question.

Options

Please assist with this formula:

=IF(Status@row, "Fully Approved", [Signing Status]@row, "Sent", NETDAYS([Fully Approved Date]@row + 1))


In this case the bold portion is my THEN calculation.

Best Answers

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    Answer ✓
    Options

    Thanks for the clarification, @Mike B . Give this one a go. Let me know if this works!

    =IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY(), "")

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    Answer ✓
    Options

    OOPS! I forgot a parenthesis. Now try, @Mike B .

    =IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY()), "")

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

Answers

  • Mike B
    Mike B ✭✭✭✭
    Options

    I also tried

    =IF(AND(Status@row, "Fully Approved", [Signing Status]@row, "Sent",) NETDAYS([Fully Approved Date]@row + 1), "")

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    Options

    Hi @Mike B - What are you trying to make the formula do? I think there's an issue particularly with the NETDAYS. What are the dates you're trying to determine? If you're trying to see the NETDAYS between the "Fully Approved Date" and today+1, this should work.

    =IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY(+1)), "")

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

  • Mike B
    Mike B ✭✭✭✭
    Options

    Hi Amber, If the two conditions are met, I wanted to calculate the number of days between Fully Approved Date and current date.

    I received the error: UNPARSEABLE

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    Answer ✓
    Options

    Thanks for the clarification, @Mike B . Give this one a go. Let me know if this works!

    =IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY(), "")

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

  • Mike B
    Mike B ✭✭✭✭
    Options

    The formula is meeting the conditions; however the result is #INCORRECT ARGUMENT set.

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    Answer ✓
    Options

    OOPS! I forgot a parenthesis. Now try, @Mike B .

    =IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY()), "")

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

  • Mike B
    Mike B ✭✭✭✭
    Options

    Perfect!!!!!! Thank you so much!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!