-
What program is everyone using to create barcodes or QR codes?
Hello! I'm using Smartsheet for event registration. Before the event, each attendee will receive a email from Smartsheet with a barcode (or QR code) that our registration team will scan on the Smartsheet app to easily find the row with that person's info and mark them checked in. This works - but my pain point is…
-
Don't Group Update Requests
Recently, Smartsheet started grouping a large number of Update Requests together. If I had 14 items needing an update request, instead of 14 Update Requests going out, Smartsheet is sending 1 out, with every single field being updated by 1 form. This is a big jump in precedence and a remarkable change from what it was…
-
How to sum a specific type in a specific date range from another sheet
This is an update to the question I asked the other day but I want to sum the total hours of certain types of employees for each month from another sheet, my columns are: Date, Title, Straight Time, and Overtime. So if I wanted to sum the total straight hours for someone who is a Foreman, what could I use? I assume its…
-
don't find Smartsheet in Teams desktop
a client of my organization told me that she can no longer find the Smartsheet application in Teams desktop/web, but it is found in the Android/Iphone versions, the application was authorized and available in Teams but it cannot be found more . I only see Smartsheet EU. Is this a problem on our side or a change that I am…
-
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
-
Change Cell Value Automation - flag or symbols
I am wondering why you cannot set the value of a flag or symbol using the Cell Change Value Automation? I cannot see how to do it. I have a flag column that I want to let the users manually set to highlight what needs to be looked at and also have the flag set automatically when certain conditions are met. I can't use a…
-
Best practice for dynamic update of dropdown list
We use dropdown lists quite a bit for our filters and dashboards and function. E.g., we track work by campaigns. However, some campaigns are added and some drop off. What are best practices for managing work that needs to be tracked in a master sheet where the drop down categories need updating once in a while?
-
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
-
How do I copy value only from cell formula to use outside smartsheet
Here is my dilemma. I have to create a cell that takes the results from other cells in the same row and formats all of it into a single text string. This is so that other team members can take the resulting string of text and paste it outside of smartsheet. However, when I go to copy the result, it only copies the formula…
-
"SAVE AS NEW"
I have a folder containing multiple sheets (17 total), which refer to sheets within that folder, as well as sheets outside the folder. I need to duplicate this folder multiple times, each referencing a different branch, however, it fails to copy/incude the cell link references at times. This is random, and 1 out of 5…
