-
Restricting views in Dynamic View by user
This discussion was created from comments split from: Restricting views in Dynamic View by filter.
-
Unable to locate Excel file for data offload using Data Shuttle
Hi, I have a weekly excel report containing project spend data. The data will change from week to week and I would like to use the data within the excel file to automatically sync into a separate document saved to a Sharepoint location. My solution would be to use Data Shuttle to acheive this as follows: Import data into…
-
Pivot App
I would like to use the pivot app. I have a business license. I don't see the pivot app in my app list. I also don't see it in the manage app menu. How do I get access.
-
Workapps Permissions and Collaboration
Hi Smartsheet community- How do I add admins to my Workapp so they can collaborate with me and make changes to the App? I can see where I can transfer ownership, I want others to work on it with me, not transfer ownerships.
-
I would like to have 2 dropdowns that reference a column in two separate sheets.
@David Jasven is it possible to link multiple columns from one sheet to another using Submit? For instance, I have a sheet called Customers. I would like the user to be able to choose a customer name from the linked dropdown in a sheet called Jobs. That choice would ultimately import the fields Customer Name and Customer…
-
Remove Blank Rows from Dynamic View
Hi SmartSheet Team, Is there a way to remove the blank rows from showing up in a Dynamic View. I thought I could created a shared filtered view that says "Created Date" is not blank and it would just show the rows with dates in them however; this doest work and the blank rows still show up. To be honest, the blank rows…
-
Data Shuttle for Time format
Hello All, I have a question on this data shuttle. Using Data shuttle, I've set column as ETA with users submit times like 02:00. However, when it comes to target sheet from data shuttle, it shows random date data like 1899-12-31. I've change Auto to Text at the data shuttle but unsure how I can make this time going…
-
Connect Power BI to Smartsheet EU Region
Hi, I'm trying to connect from Power BI to data in the Smartsheet EU region. Every solution I find seems to use the default instance, with no way to configure for use with the Europe instance. I've already reviewed the following options: I'm trying to avoid building out some API solution from scratch. Has anyone used a…
-
Collecting Data from Smartsheet Form
I am trying to collect data using a Smartsheet Form. More specifically, I am trying to send the Form to verify that an item has been discontinued with a supplier. I have a column titled ITEM NUMBER, in Smartsheet and will manually add the Item Number, can this number auto populate into the form so my supplier doesn't have…
-
Data Shuttle Workflow - Run on Attachment
I have been trying to figure out for a few weeks now how to set up Data Shuttle to run a workflow based on an attachment. I was sent a video of someone who dropped their Excel sheet into their Smartsheet directly and the workflow ran automatically. I have many sheets for the database that I am building and thus have 2-3…
