Current Stock Formula


Ok I want to keep track of current stock but have a few different places stock can be in put and taken out.
I have an Inventory sheet with In & Out column (+=added stock and -=taken away stock)
Manual Sale sheet with Quantity Sold column
Play sheet with Quantity Sold column

I originally typed =[Levels!Inventory In & Out] + [Manual Sale!Quantity Sold] + [Play!Quantity Sold] but its not working its only showing “Levels!Inventory In & Out , Manual Sale!Quantity Sold , Play!Quantity Sold”

How do I fix this

Looks like you’re trying to use spreadsheet-type syntax in Appsheet expressions. Please read up more on how Appsheet expressions work.

1 Like