IF statement (Inventory status updated from "order needed" to "reordered")
Hello,
I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status"
I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying to troubleshoot this for over an hour by scouring forms on this site and I still haven't determined a solution
Thanks for any help
Noah
Best Answer
-
You could put the Checkbox in with your Stock Quantity Check. The excerpt would be:
IF(AND([Stock Quantity]@row < [Reorder Point (ROP]@row, [Order Status]@row = 0), "Reorder Needed"
That will only put Reorder Needed if the Order Status was not checked. Then you can put your conditional IF the checkbox is checked then say Reorder at the end.
Also, in your screenshot you have one too many parentheses.
Answers
-
I may be oversimplifying, so please @mention me with clarification if this is not what you're asking. But the solution as far as I can tell is:
=IF([Order Status]@row = 1, "Reordered")
-
@David Tutwiler Thank you! I need to clarify a little more. There are multiple functions for this one cell.
I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? It is still showing me that this function is "unparseable"
Thank you so much for the help! I really appreciate it
-
You could put the Checkbox in with your Stock Quantity Check. The excerpt would be:
IF(AND([Stock Quantity]@row < [Reorder Point (ROP]@row, [Order Status]@row = 0), "Reorder Needed"
That will only put Reorder Needed if the Order Status was not checked. Then you can put your conditional IF the checkbox is checked then say Reorder at the end.
Also, in your screenshot you have one too many parentheses.
-
Hi David,
This worked for me:
Thanks!
Noah
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!