I've created a smartsheet to track every unit we sell of one of our particular product lines.
The sheet includes the unit's serial number, model number, client name, client PO number, internal 'project number', current location of unit (Ex: "On order", "Johnny's bench", "Software dept.", "Warehouse", "Shipped - En Route", "End User") and a number of other columns for product options and other various pieces of information.
I would like to be able to have my everyone in the company have a way to scan or search the serial number of the unit and instantly pull up everything for that particular unit and be able to change the location of each unit as well as input other information as it is made available. Though I'd obviously like to take the cheap/free route as much as possible, I'm open to any third party SaaS, or a PC or mobile app if required.
We're always in a rush to get things done and out the door. Trying to have everyone sign in to smartsheet, navigate to the production tracking sheet, find the row for the unit, and then navigate to the column for the data they need to update is unfortunately more challenging than it should be.
The Dream:
If 'Bob' is working on unit with the serial 34584n7d3, he could either scan the serial bar code or just search for "n7d3", instantly be brought to a page displaying all relevant information, update the location to "Bob's desk", and then get to work continuing the production process.
Anyone have any good ideas on how to get rolling or am I wasting my time?