-
Data Shuttle and Cell Linking
I have a destination sheet that uses data from cell links from different other sheets. I created a source sheet using Data Shuttle that runs on attachment. The workflow runs correctly, but the destination sheet doesn't update. It says that the cell link is invalid because it got deleted. I need that destination sheet to be…
-
Data Shuttle and Date Format
Hello, I have a working .csv file with the column in the following date format: mm-dd-yyyy It imports well to the smartsheet date column via the data shuttle in the following format mm/dd/yyyy, but it will not import if the date field in the smartsheet is date restricted specifically. Furthermore, I am not able to import…
-
Data Shuttle - Input Expressions
I am trying to fix an issue that I have with my import. I have a .csv file that is generated from an MS Project project plan. The issue I have is with the % Complete column. In the .csv file the value is 100%, but when importing it becomes 10,000% in the Smartsheet plan. I thought I might be able to create an expression…
-
Smartsheet to salesforce integration
Hi Team, I have scenario on smartsheet salesforce integration, without using the other third party systems,like as (Mulesoft or other systems), I tried using the smartsheet developer account to enable the salesforce connector, but it assking need to purchase salesforce connect, looks I don't see the prizing details and…
-
Control Center & Automated "Move to another Sheet" Issue
I'm working on my project plan sheet to use with Control Center. I support a multitude of services and when a Client Contact field is populated, that tells me that is a service the client purchased. My goal is to remove the services (parent & child rows) of the ones not purchased. I created a column Purchased Service to…
-
Creating Project Timeline Visualizations-Not Gantt View
I am wondering if anyone has experience with creating a high-level project timeline view to put on a dashboard--and I am not talking about a Gantt view. What I am trying to do is avoid my customer from having to continue producing PowerPoint slides manually of the data they are managing in Smartsheet. Ideally, they would…
-
Control Center - Add Existing Projects to Intake Sheet
Is there a programmatic way of adding existing projects to the Intake Sheet via Control Center or other means without duplicating respective projects? I've been using Control Center to provision projects in my portfolio, but want to add projects which have already been created to the Intake Sheet to promote a unified way…
-
DataShuttle Error: Access Token is Invalid
Hi, I have a datashuttle that's been working for several weeks but today gave the error: Workflow Execute: Your Access Token is Invalid. I didn't use any API to create this datashuttle, and we don't have JIRA connected.
-
Data Shuttle Kicked off by Power Automate Flow
I am using a Power Automate Flow to create an .xlsx file and then run an Office Script on it. This is done within 1 flow in Power Automate. The file is saved to One Drive. Currently I have a Data Shuttle that I run manually to take the updated file and load to Smartsheet. Is there a way to use Power Automate to run the…
-
Can I allow used to add attachments/comments on dynamic views on a line to line basis??
I need to consolidate dynamic views. I currently have two views, one that allows users to add attachments and commends and the other does not allow attachments or comments. All other headers are exactly the same. I'd like to combine the two dynamic views. Is it possible to allow users to add attachments and comments on one…
