Parts of a whole inventory suggestions

edited 12/09/19 in Formulas and Functions

Hello! we use Smartsheet mostly for inventory management and I was wondering if anyone had some suggestions on how to write a formula to automatically subtract the parts that go into each item while also subtracting the completed part. I currently link in the part inventory from one sheet and update it there so that it links to the main page, but this requires manual updating. 

Example Complete Item A (CIA) contains items a b and c and Complete Item B (CIB) contains items a d and e. how would I account for when I release CIA to deduct from items a b and c, while updating item a for CIB as well?

We have a few items that share a main item and then have different sub items, and the sub items appear in multiple completed items with different main items. I'm sure there is a way to do this with some of the recent updates, but I don't want to undo a system that works.

Thank you!  


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!