Smartsheet Inventory Workflow Automation

Замовник: AI | Опубліковано: 15.01.2026
Бюджет: 3000 $

I need a complete Smartsheet workflow that streamlines how we move inventory requests through warehouse and purchasing. Here’s the flow I have in mind: • A user opens a simple Smartsheet form, manually enters one or more SKUs and the quantities they need, then submits. No extra sign-on layers are required; everyone will already have access inside our shared Smartsheet workspace. • The submission lands in an “Open Requests” sheet. Warehouse staff confirm on-hand stock by updating a Fulfillable Yes/No column and entering the picked quantity. • When all lines are marked “Yes,” Smartsheet automatically emails the originator a detailed fulfillment notice that includes the SKU list, quantities shipped, and any tracking or reference numbers. • If any line is marked “No,” the row is instantly copied (or moved) to a “Purchasing” sheet. Purchasing receives an alert to raise a PO, enters the PO #, vendor, and expected delivery date, and Smartsheet then sends the originator a second email containing the full inventory request, the new PO #, and ETA details. • Once the purchase order is received, a final status update should close the loop and archive the row. Required deliverables: • All Smartsheet sheets, forms, automation rules, and cross-sheet references fully built and tested. • Clear, concise documentation outlining sheet structure, column logic, and how to tweak automation rules in the future. If you’re comfortable leveraging Smartsheet’s forms, workflow automation, and notification features to create this end-to-end process, let’s talk.