Can I automatically move rows to another sheet only when two cells containing numbers match?

Sam Lugiano

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.

Thanks,

Sam

SoS | Dan Palenchar

You can add a column such as "Outstanding Quantity" and calculate the difference from the number ordered and actual quantity, this could generate a report with a list of all partially filled orders. If you send more, you can update actual quantity. Build the report so that it only shows orders with an Outstanding Quantity greater than 0.

This is just one way, there are likely many other options, for example having a separate sheet for partially filled orders and move row automations to go from new orders to partially filled or complete and from partially filled to complete.

Sam Lugiano

Thank you! I added an "Outstanding Quantity" column to the Orders Fulfilled sheet and used Workflow Automation to send the items back to the Order Request sheet that were not "0".

SoS | Dan Palenchar

You can add a column such as "Outstanding Quantity" and calculate the difference from the number ordered and actual quantity, this could generate a report with a list of all partially filled orders. If you send more, you can update actual quantity. Build the report so that it only shows orders with an Outstanding Quantity greater than 0.

This is just one way, there are likely many other options, for example having a separate sheet for partially filled orders and move row automations to go from new orders to partially filled or complete and from partially filled to complete.

Sam Lugiano

Thank you! I added an "Outstanding Quantity" column to the Orders Fulfilled sheet and used Workflow Automation to send the items back to the Order Request sheet that were not "0".