Parts of a whole inventory suggestions
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.
Help Article Resources
Check out the Formula Handbook template!