Cross sheet column subtraction

Options

I have two sheets where I am tracking inventory, one sheet contains data for material available, and the other for material used, given that not everyone has access to all sheets and I want to create a report where I can display the material available ( basically the difference), Is there a way to do a cross sheet column subtraction without linking cells? and even if i have to link cells can I link an entire column so that it auto updates whenever someone updates and adds a row?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!