Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Remotely fill in a new row on another sheet.

Hello,

I have two separate sheets that need to be connected. One is an inventory sheet of all raw materials in stock, and the other is a record of all raw materials delivered.

If we receive a delivery of a type of raw material we already have some in stock of, the quantity of that material is simply updated in the inventory sheet. Each row of the inventory sheet contains each raw material we have. To calculate the quantity of that raw material, the quantity cell uses SUMIFS to look through the delivery sheet to find all the rows with that material's name and some the quantities delivered. 

However, we may also receive a shipment of a new material that we did not previously have in stock. Therefore, new material does not yet exist in the inventory sheet. This new material will be entered as usual into the delivery sheet. 

How do I

1. recognize that this new material name does not exist in the inventory sheet

2.Then, automatically fill in a new row in the inventory sheet using the information of this material from the delivery sheet. 

Please let me know if I can clarify anything. Thanks!

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions