Can I automatically move rows to another sheet only when two cells containing numbers match?
In my Inventory System I have an Order Request sheet that captures order info by completing a Form. Once that order is filled it is automatically moved to an Order Fulfilled sheet using Automated Workflows. However, sometimes we can only partially fill the entire order amount. For example, if an office orders 10 Face Masks and we can only send 5, I would like to keep the original order with the remaining 5 Face Masks on the Order Request sheet as well as send the 5 fulfilled to the Order Fulfilled sheet.
I currently have it set up through a simple automation where, when the Actual Quantity Filled is not blank, it moves the entire row to the Order Fulfilled sheet. I can send screen shots if that will help explain better.