-
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…
-
Pivots nots working ?
Hello team, It's been a few hours I've been trying to create now Pivot table but none of my attempts today were successful. All Pivot creations are still "in process" Is someone else experiencing the same issue ? Thanks Pierre-Eric
-
Is it possible to have different bill rates for one person in Resource Management
Hi, Is it possible to have different rates for the one resource in Resource Management. For example, on project A I might have a sell rate of $100 per hour, but on project B my sell rate is $110 and project C my sell rate is $95. Thank you, Adam
-
Issue with Smartsheet Cell Limit - Data Shuttle
I'm trying to use Data Shuttle to import data into a Sheet upon attachment of an Excel workbook to the same sheet. When I attempt to run this Data Shuttle, I am getting an error that I have exceeded the 500,000 cell limit. The parameters of my source Excel sheet are as follows: Cells: 401,668 Columns: 40 Rows: 10,280 I…
-
Smartsheet API Add attachment to Sheet using Powershell
I am building a Powershell module. Yes I know there is the C# SDK but I do not want that as a dependency for this Module. I am struggling with this API Call: Attach File or URL to Sheet This is my code: $BaseURI = "https://api.smartsheet.com/2.0" $Id = {smartsheet id} $filename = "MyDoc.docx" $mimetype =…
