I’m trying to build a merchandise tab for my business that helps track inventory. I have an available inventory tab that has the total shirts we have in stock by design and size. what i’m trying to do is set up a tab that you put in the number of quantity sold for the day and it reflects on the total available inventory. But then I want those values to overwrite the available inventory for the next day. is this possible?
