Oct 27 2021 07:56 AM
i want to block entries on the cell when my stock is zero, eg if there is stock of 40 no, and i will use 40 in 20 days there will be 0 stock if i go to deduct the stock the entry must not happen in that cell and pop must show that the stock is zero,
Sep 27 2023 01:03 PM
To prevent data entry when your stock reaches zero, you can set up a validation rule in your spreadsheet or data entry system. When the stock quantity is zero, attempting to deduct stock in a cell will trigger an error message or a pop-up alert, indicating that the stock level is insufficient for the requested action. This ensures that no entries can be made when the stock is depleted, helping you manage your inventory effectively.