# IF Then [Incorrect Argument] Question.

Options
✭✭✭✭

=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.

• ✭✭✭✭✭✭
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

• ✭✭✭✭✭✭
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

• ✭✭✭✭
Options

I also tried

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

• ✭✭✭✭✭✭
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

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
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

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
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

• ✭✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!