Compiling Inventory Data Living Across Multiple Columns

Shay ✭✭
edited 10/02/20 in Formulas and Functions

Hi everyone!

I am in the process of creating an inventory tracking sheet. Long story short, i built a form to keep track of inventory being taken out, and it offers 5 chances (so they drop into 5 different columns) to track any products counts taken out. I would like to be able to take those 5 numbers and compile them into one cell on my formula sheet. Any ideas how i would do that? The goal here is to keep a running count of live inventory, but i can only do this if i am able to bring all those numbers into the one cell! I've added a screenshot of 2 of the columns, and my formula sheet for reference. Any help on this would be so greatly appreciated. Its really stumping me!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!