I need help with setting this up. I am wanting to auto-calculate item quantities from two separate sheets. It seems fairly simple, but I’ve tried several logics and I cannot move forward.
I’ve tried creating a relation between both sheets using the “Current Stock” columns, but the relation output is showing the items.
Again, just want both “Current Stock” columns to output a total calculations between the two. Also, would I need to have the Item names to match?