-
Merged: We need an activity log for automations (especially emails sent)
This discussion has been merged.
-
Why does the date default to 2025
I'm working on a Smartsheet for items that are in 2026 and I have some columns that are set to the date field formatted like 15-May-26. The issue is that when I enter the date like 15 May, normally I can hit enter and it would enter the year, but for some reason, it is still set on defaulting to 2025 as the year. Of course…
-
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…