Compiling Inventory Data Living Across Multiple Columns

Shay

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!

Screen Shot 2020-10-01 at 10.05.26 PM.png

Screen Shot 2020-10-01 at 10.03.32 PM.png

Andrée Starå

Hi @Shay

Not sure I follow, but it sounds pretty straightforward.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Shay

I was actually able to figure this one out by playing with my formulas. Thank you for the help!

Andrée Starå

@Shay

Excellent!

Happy that you figured it out!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!