Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I am new to Smartsheet and trying to setup an Inventory Management system. We are a gravel and construction company that has multiple products in multiple pits. I am looking for the best way to setup a sheet that uses a form the operators can fill in that would populate the data sheet. Then I think I would need another master sheet that would pull the info from the data sheet to give me a live running inventory system. Not sure if this is something that can be done or not.
Hi @Michael Payment
Smartsheet would be perfect for this use-case.
Here are some templates that could work or be an excellent starting point.
Would any of those options work/help?
I hope that helps!
Let me know if I can help in any way!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
@Andrée Starå have you had any issues with smartsheet not finding the barcode? I have entered multiple barcodes into Smartsheet and no luck when I use my app to "search" for the barcode. I even tried it with your "Barcode Inventory" template. I scan the barcode with the SS search feature on my iphone, and it keeps saying "no results." I have made sure there are not any filters in my search. App is also up to date.
I have created two collections in one of the Workspaces that I own. One of them I am able to edit and delete. The other one is missing the Rename, Share and Delete options in the kebab menu. Any idea why this is the case?
I'd love some help with the date & time formatting within the same column. I am using a Data Mesh to add/update cells, and it is losing the time in the upload (I think due to formatting). In the original Excel the "Sign Up Timestamp" is 9/16/2025 5:15, but I can't seem to change the formatting to show both the date and…
@Paul Newcome I have 2 worksheets; Master List of site locations Tracker This worksheet pulls in some data from the Master List, i.e., site name, site address, site contact, etc. using and INDEX/MATCH with the 'Site #' as the unique identifier When the Site Address updates I want an alert to 'send to everyone shared to…
