Workflow for Tracking Inventory Counts and Bin Locations
I am trying to setup a sheet to keep track of when we count bin locations in our warehouse and how often. I would like every bin to be counted at least once ever 12 weeks. In our bin locations column, I have a multi-checkbox setup with all 403 of our bin locations in it. We typically count 5-12 bins a day. Can I setup an automation to tell me when a bin needs to be counted if it is outside that 12 week window?
I plan on making a metadata sheet as well as a dashboard for future metrics as well.
Help Article Resources
Check out the Formula Handbook template!