IF statement (Inventory status updated from "order needed" to "reordered")

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!