-
End users able to create their own filters on sheets in WorkApps?
I was just trying workapps for the first time and it appears to me that unless you are the admin/owner of the workapp, you can't create a new filter while viewing a sheet in workapps. This makes workapps useless for so many scenarios. Is this the case? It blows my mind that they would design it this way. I feel like no…
-
Data Shuttle Upload Workflow Unique Identifier Issue
Hi I have a question regarding the use of upload workflows and the unique identifier in data shuttle. I have an upload workflow that updates rows on my Smartsheet from an external database. To pull from this external database, I have the unique identifier set as the code from the external database. The problem is there are…
-
DocuSign Generate Document Issue
I currently have a template mapped out with the columns I want text to be generated in, however I have an issue where if there's too much text, it will overflow into the next lines and obscure the text of other fields. I know when you generate a document as a PDF it will adjust the field/text for it to fit, but I'm lost at…
-
Pivot app - and Count function
I've created a pivot table to summarize the number of task completions in a month. From this, I want to calculate the average monthly completions. The problem is, the table does not put a '0' in the months with no completions, so the averages are not calculated correctly (see below - 1 isn't the monthly average when only 1…
-
Does anyone else have an issue with the date filter when using DataTable Connections?
I have an issue with DataTable and Sheet Connections where I will setup a connection and put in a date range filter between two dates 1st - 30th June, press save and the table will update with the data from 31st May and 29th June! I go back in and the connections filter has changed to the 31st May and the 29th June! In…
-
What is the difference between Bridge, Data shuttle, datamesh and dynamic view
Hi all, I'm confused on the roles of each of these products. Could someone please cover these for me? Thanks
-
Active Directory Integration
Hello, We have recently setup our Active Directory Integration. Are we able to pull data that is included in AD into a sheet in Smartsheet? For example: Name, Title, Department? And if so, how? Thanks, Melitta
-
Why is my global update to add profile data coming in blank in tests?
Hi all, I'm trying to make a global update to add a new profile data point (created date) to metadata and summaries. I've tried doing it with both the system created date column and a helper column replicating the created date column (read in another discussion that I should try that). Both result in an incomplete data row…
-
Barcode Scanning for Small Barcodes
I'm not sure how popular the barcode scanning function is in Smartsheet, so I'm hoping there is a user base that can help me. We have an asset inventory list that includes barcode values. The barcodes are Code-128, which is readable by Smartsheet. The barcodes exist on stickers on each piece of equipment. The stickers are…
-
Data Shuttle Filters
Hello, Is it possible for have a filter for an upload workflow in Data Shuttle be based on a date. I am trying to only pull in data from an Excel file where the value in the column is on or after 5/31/2023. Thank you
