Add Quantities from Two Separate Sheets

[AjBruce]

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?

Thanks,
AJ

Sheet A

Sheet B

[ThinhDinh]

@AjBruce

I’ve tried creating a relation between both sheets using the “Current Stock” columns, but the relation output is showing the items.

The relation’s visual presentation is just a way to show that it finds a match, or multiple matches, not the actual value you’re getting back.

Let’s say you want to calculate the total in Sheet A, create a relation to sheet B and return the actual count in Sheet B using a lookup, then a math column to add the two stock counts together.

I would advise using a reliable column as the connector for the relation. Usually I use IDs, but if you’re confident your items won’t ever have a duplication then just go ahead.

[AjBruce]

Thanks ThinhDinh! I’ve been beating myself up on this and yes it appears I made it much more complex then I needed to. As far as duplication, IDs would be ideal…

[AjBruce]

Also to include, the Item names needed to match for the relation to pull the counts.