How can I create a material inventory and order form in the same sheet
I am very new to Smartsheets and am trying to streamline inventory and how our partners order materials from us. Currently, partners email members of our team and someone fulfils and tracks the order manually in an excel sheet.
I want to create a sheet that tracks inventory with an order form that subtracts from the total. I also saw that alerts can be sent when inventory reaches a certain threshold. I would truly appreciate any advice and insight.
Thank you in advance!