-
Data Shuttle Offloading Wrong Data?
Hello, I have a main data source which collects project information from different vendors. Figure 1. Example of main sheet row To work with outside vendors, we have public facing sheets that we offload data to using data shuttle. Figure 2. Data Shuttle Offload Criteria This data is then uploaded to the company's sheet…
-
Mass Transfer of Ownership of Dynamic Views
Hello, I need to transfer ownership of a number of Dynamic Views from myself to someone else. The issue is that I have over 400 views. Is there a way to do a mass transfer so I don't have to go into every view and manually transfer ownership?
-
Dynamic View - View by sheet filter date - sometimes not working
Hi everyone We have an issue in Dynamic View where the "View by sheet filter" sometimes is not working. This is the filter: So it's supposed to only show todays and past records, along with the two other conditions. The issue is that sometimes it doesn't show todays records. It seems like it's stuck on yesterdays view.…
-
"Record No Longer In View" / Apostrophes in Data from Dynamic View
Background information: I am trying to track allocation percentages of time that employees are dedicating towards a project, so I am having them fill out a dynamic view that has a drop down with increments of 0%-100% for each week (pictured below). The employees do not have access to the source sheet based on sensitive…
-
DocuSign/Generate a Document with Multiple Mappings on single Sheet
New to DocuSign integration and performing some test messages. Have run into some challenges. Situation: I have a single Sheet that lists all our active projects. When a PM needs to obtain signoff for a single row there are multiple "forms" they could use depending on the project type, therefore I have created a Smartsheet…
-
Standard Naming Convention For Projects in Control Center
Hello - I am looking to create a standard naming convention for all my projects. I want it to say, "Project Toolkit - INSERT PROJECT NAME". When I went into Control Center to configure this, It wasn't clear to me how to configure this under the naming section. The Prefix should be the text, "Project Toolkit - " and the…
-
Filters on Embeded PowerBI Dashboards Not Visible
Hello, Community! In PowerBI desktop, I created a dashboard, published it to PowerBI online and embedded it on a Smartsheet dashboard. On the first two, the filters added are visible and work just fine. In Smartsheet, though, the filters are not available. What did I miss? @Philip Robbins, I came across your article but…
-
Multi-Tier Projects
Hey everyone, I am having the hardest time trying to figure out how to set up a multi-tier project. Let's say I have a specific workspace set up for a specific project. I am using an intake sheet in my Admin Workspace to create these for each employee using Control Center. Under the project workspace, I have a folder for…
-
Data Shuttle - Adding New Records
Hi all - I have a Data Shuttle process that runs when a new attachment is added. The goal of the process is to add all records in the attachment to the sheet, but I'm struggling b/c I need to map a Unique Column according to Data Shuttle for the Destination Sheet. The process fails to load all of the sheet rows because…
-
Sharing Dynamic View to Outside Vendor
How do you share a dynamic view to an outside vendor who may not have a Smartsheet account? The email address was added to Shared Users on the Sharing tab. Restrict View by Current user (General tab) is filtered on the column containing the vendor's email address. How do they get notified/access to the view? (May not have…