-
Collecting the most recent submission
Hello, I have set up a sheet in which a form will submitted with 4 columns; a specific label (from a dropdown list), and then up to three barcodes. On the grid I also have a hidden created date column. I am then wanting to create a separate sheet that collates the most recent barcode for each column for label for the day.…
-
Highlight changes icon, print icon and view option no longer appear in published sheets
I have a number of published sheets, and in recent weeks the bar just below the sheet name, which contained the print icon, the view drop-down menu and the highlight changes icon have disappeared. I haven't done anything on the back end to the underlying sheets. Unfortunately I've put a ticket in for support help (on about…
-
Generated PDF is blank
I created my fillable PDF, uploaded it into my Smartsheet and pulled over the columns that I wanted populated on the sheet. When I ran it the first time, with a different PDF file, it worked. Then my manager wanted some items on the PDF changed, so I created a new fillable PDF file, uploaded it into my Smartsheet, pulled…
-
How to Cascade Task List Updates Across Multiple Workshop Instnaces
We run workshops multiple times per year (e.g., quarterly). Each instance uses the same task list and are all on the same worksheet. If someone updates the list for one quarter (e.g., adds a new item to print) they have to manually update the list for every other quarter. Is there a way to cascade updates so that changes…
-
Calculate percentage based on drop down response from one cell and value of another cell
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
-
Time columns from Excel to Smartsheet via Data Shuttle
I'm trying to Data Shuttle an Excel doc from another system into Smartsheet. All is fine, except for the Start Time and End Time columns. They look like this in Excel: But when I pull them into Smartsheet via Data Shuttle, the columns show only the date part of those columns: I'm really only interested in the time…
-
Undelete a Sheet as an ADMIN and Owner account is deleted
I recently switched licenses and had my assets transferred to another license owner. After obtaining the new license, i had the owner transfer back the workspaces. For some reason, the sheets within the workspace did not get transferred over. Now, the account of the license owner has been deleted, and i can see the sheet i…
-
Access to add data to sheets
we have a lot of sheets that users need to enter data and add attachments and the like. what permissions are needed for this? it seems we have some users who are admin - but they don't really need to be. so how are the permissions set to be able to add data to sheets, and remove from being admins?
-
Two columns with the identical name in one sheet
Since I tried to report this as a technical issue and was redirected by a useless AI to this Community, I'd like to ask if anyone here has had the same experience? Screenshot attached, and needless to say, it is not convenient at all.