Stock In Out Balance Tracker in Google Sheets | Inventory Management

[@anbhaysadh1625]

Can we add alert for low balance in the final balances

[@spreadsheet_power]

Yes we can, suppose, for example, if 20 unit is the low balance, use this formula beside the stock balance column.
=IF(H5

[@anbhaysadh1625]

Can i use the same sheet in excel ???

[@spreadsheet_power]

Yes, you can download it as Excel sheet

[@anbhaysadh1625]

I am not able to enter low balance alert and also need to put red color and green color

[@anbhaysadh1625]

Also i need check if any product is sold to A person
How can I check that A person has this much products after some days
That means how much stock I have sent to A person as I have to send products to multiple people

[@PosengolKitchawen]

Can we add same products for stock in again the secound time?

[@spreadsheet_power]

Yes, definitely

[@PosengolKitchawen]

Thanks,

[@anbhaysadh1625]

Also can we put names of person what product is issued to which person
As I have to do for my manufacturing concern