This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Current Stock Formula

Posted on 05-25-2021 10:12 PM
Clark_Bentley
New Member
Reply posted on --/--/---- --:-- AM

Hello!

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

0 1 109
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

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

Top Labels in this Space