Inventory Status: Reordered (How do I do it?)

Noah Webster

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

Genevieve P.

Hi@Noah Webster

Try this:

=IF([Order Status]@row = 1, "Reordered", IF([Stock Quantity]@row < [Reorder Point (ROP)]@row, "Reorder Needed", IF([Stock Quantity]@row >= [Reorder Point (ROP)]@row, "OK")))

This is what it says:

If the Order Status is Checked (no matter what the Reorder Point says), then say "Reordered"

=IF([Order Status]@row = 1, "Reordered",

Otherwise,if the Order Status isnotchecked,andif the Stock Quantity islessthan the Reorder point, return "Reorder Needed"

IF([Stock Quantity]@row < [Reorder Point (ROP)]@row, "Reorder Needed",

Or otherwise,If the if the Order Status isnotchecked,andif the Stock Quantity is大于或情商ual tothan the Reorder point, return "OK"

IF([Stock Quantity]@row >= [Reorder Point (ROP)]@row, "OK")))

Did that work for you?

Cheers!

Genevieve

Genevieve P.

Hi@Noah Webster

It would be helpful to know a bit more about this formula and exactly when you want each of these outputs to be returned.... when should it be Blank? When should it say "Reorder Needed"? When should it say "OK"? When should it say "Reordered"?

Once we know the criteria for each of these outputs, we can build theIF statementto return what you want, based on this criteria.

Logic formulas readleft - to - right, andstopas soon as they reach a criteria that works. So, if the first thing you want it to look for is if the checkbox is checked, write that as the very first instruction... ex:

=IF([Order Status]@row = 1, "REORDERED"

Then the rest of the instructions will only happen if the Order Status in that rowis notchecked.

I also see that your first statement is counting one cell. Is that to see if it's blank or not?

COUNT([Item Name]@row)will either return a 1 if there's content in that cell or a 0 if that cell is blank. Is that the intended instruction?

Let me know if this makes sense or if you still need help!

Cheers,

Genevieve

Noah Webster

Hi@Genevieve Pthanks for the response.

"OK" is when the Stock Quantity is greater than Reorder Point

"Reorder Needed" is when Stock Quantity is equal to or less than the Reorder Point

"Reordered" is when the check box is checked, even if the stock quantity is less than the reorder point

I am new to Smartsheets (I was introduced to the software last week) so this is all very helpful.

The first part of the function that returns "" is probably not necessary.

Thank you,

Noah

Noah Webster

Am I getting closer? This is still giving me an error

Genevieve P.

Hi@Noah Webster

Try this:

=IF([Order Status]@row = 1, "Reordered", IF([Stock Quantity]@row < [Reorder Point (ROP)]@row, "Reorder Needed", IF([Stock Quantity]@row >= [Reorder Point (ROP)]@row, "OK")))

This is what it says:

If the Order Status is Checked (no matter what the Reorder Point says), then say "Reordered"

=IF([Order Status]@row = 1, "Reordered",

Otherwise,if the Order Status isnotchecked,andif the Stock Quantity islessthan the Reorder point, return "Reorder Needed"

IF([Stock Quantity]@row < [Reorder Point (ROP)]@row, "Reorder Needed",

Or otherwise,If the if the Order Status isnotchecked,andif the Stock Quantity is大于或情商ual tothan the Reorder point, return "OK"

IF([Stock Quantity]@row >= [Reorder Point (ROP)]@row, "OK")))

Did that work for you?

Cheers!

Genevieve

Noah Webster

Hi @Noah Webster<\/a> <\/p>

It would be helpful to know a bit more about this formula and exactly when you want each of these outputs to be returned.... when should it be Blank? When should it say "Reorder Needed"? When should it say "OK"? When should it say "Reordered"?<\/p>

Once we know the criteria for each of these outputs, we can build the IF statement <\/a>to return what you want, based on this criteria. <\/p>

Logic formulas read left - to - right<\/strong>, and stop<\/em> as soon as they reach a criteria that works. So, if the first thing you want it to look for is if the checkbox is checked, write that as the very first instruction... ex:<\/p>

=IF([Order Status]@row = 1, "REORDERED"<\/strong><\/p>

Then the rest of the instructions will only happen if the Order Status in that row is not <\/strong>checked. <\/p>

I also see that your first statement is counting one cell. Is that to see if it's blank or not? <\/p>

COUNT([Item Name]@row)<\/strong> will either return a 1 if there's content in that cell or a 0 if that cell is blank. Is that the intended instruction?<\/p>

Let me know if this makes sense or if you still need help!<\/p>

Cheers,<\/p>

Genevieve<\/p>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"Noah Webster\",\"userID\":128020}}},{\"insert\":\" \\nIt would be helpful to know a bit more about this formula and exactly when you want each of these outputs to be returned.... when should it be Blank? When should it say \\\"Reorder Needed\\\"? When should it say \\\"OK\\\"? When should it say \\\"Reordered\\\"?\\nOnce we know the criteria for each of these outputs, we can build the \"},{\"attributes\":{\"link\":\"https:\\\/\\\/help.smartsheet.com\\\/function\\\/if\"},\"insert\":\"IF statement \"},{\"insert\":\"to return what you want, based on this criteria. \\nLogic formulas read \"},{\"attributes\":{\"bold\":true},\"insert\":\"left - to - right\"},{\"insert\":\", and \"},{\"attributes\":{\"italic\":true},\"insert\":\"stop\"},{\"insert\":\" as soon as they reach a criteria that works. So, if the first thing you want it to look for is if the checkbox is checked, write that as the very first instruction... ex:\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"=IF([Order Status]@row = 1, \\\"REORDERED\\\"//www.santa-greenland.com/community/discussion/72580/\"},{\"insert\":\"\\nThen the rest of the instructions will only happen if the Order Status in that row \"},{\"attributes\":{\"bold\":true},\"insert\":\"is not \"},{\"insert\":\"checked. \\n\\nI also see that your first statement is counting one cell. Is that to see if it's blank or not? \\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"COUNT([Item Name]@row)\"},{\"insert\":\" will either return a 1 if there's content in that cell or a 0 if that cell is blank. Is that the intended instruction?\\nLet me know if this makes sense or if you still need help!\\nCheers,\\nGenevieve \\n\"}]","format":"rich","dateInserted":"2020-10-28T17:00:04+00:00","insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-27T07:46:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/267339#Comment_267339","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/267339#Comment_267339

这工作,非常感谢!

Genevieve P.

I'm so glad this worked for you!