-
Issue with Scanning Multiple Barcodes Without Overwriting
Hi everyone, I’m using a Smartsheet form, where I need to scan multiple barcodes into a single field. However, each new scan overwrites the previous one, even when I add a separator. I’d like each scan to add to the list in the same field without replacing the previous codes. Any suggestions on how to keep all scanned…
-
Importing 2 separate excel files into one sheet
Hello! I'm looking for some recommendations on how I can pull 2 separate excel/csv files into one sheet. Data from the sheet will be used to create reports that will feed a dashboard. I don't have access to data shuttle.
-
Subtraction Formula?
I have a value of 02 and I would like to have a formula that would return 01. Is the a way to do this? 02-?? = 01
-
Matrix Sheet based on date and personal resource assigned
Hello all I'm a bit stumped by this and would like assistance on how to create my formulas. I'm tasked to create a sheet, view, or dashboard to summary our master data sheet turning it into a matrix style sheet. This matrix style sheet will pull data from several other databases within smartsheets. The matrix should…
-
Index matching formula for cross referring between sheets
Hi everyone, I would like to get help with a formula related to index matching. I have two sheets, for the purposes of this discussion - Sheet A and B Sheet A (only has these two columns) Sheet B is a grid view sheet that has a Smartsheet intake form. My ask is - When the intake form is submitted, if Dermatology - Dr. Ozog…
-
add multiple column once.
I don't know if it is possible to have a question when we request to add a column to right or left, suggesting how many we want to add? and then we can name them, or make them all the same properties.
-
Moving Attachments Across Sheets
I have a situation where I need to be able to move attachments across sheets as part of our workflow. I've looked into using Automation and Data Mesh and don't see how I can do this without Automation→ move row functionality. I don't want to move the whole row, just the attachments. I'm already using Data Mesh to connect…
-
Lag in Workflow - When is Smartsheet Checking Criteria?
I have a simple workflow with a trigger on When rows are added or changed. The field is status field that I would like Smartsheet to add a timestamp when the status changes: What I have noticed is there is a two minute lag in this simple automation, however, I am also noticing that it's not just a lag. What I see if…
-
Inventory Management System
I am looking for a way to have our maintenance team be able to manage a stock inventory on specific machine parts. I would like for them to use their phones to scan on to either the QR or barcode and it reference my sheet. From there they could update the inventory, and I would have automation set up to alert that an…
-
Meet Jason Tarpinian, our October Member Spotlight! 🎉
4, 6, 8, 10, let’s go @Jason Tarpinian! We’re so happy to feature this Community Champion as our October Member Spotlight. Jason is a Project Manager of Technology at Sevan Multi-Site Solutions, and calls Minnesota home. About seven years ago, as an Assistant Project Manager, he first used Smartsheet to manage hundreds of…
