IF Then [Incorrect Argument] Question.
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
-
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
-
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
-
I also tried
=IF(AND(Status@row, "Fully Approved", [Signing Status]@row, "Sent",) NETDAYS([Fully Approved Date]@row + 1), "")
-
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
-
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
-
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
-
The formula is meeting the conditions; however the result is #INCORRECT ARGUMENT set.
-
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
-
Perfect!!!!!! Thank you so much!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!