-
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 =…
-
Gmail Extension and Row Attachments
When I use the gmail Smartsheet extension tool to send an email to a row on a Smartsheet with attachments, the attachments do not show up on approvals that are then generated. Attachments are only being included on approvals if they are directly uploaded to a row. The only way to see an…
-
Shared Filters
Hello. I have Editor-Can Share access to a Smartsheet outside my organization. When I create filters, there is no box to check so that I can share it. I can see the filter. But the owner of the sheet cannot. I have attached my Create New Filter view. Thank you for your help.
-
How to move a sheet based on a condition under an automation to another folder automatically?
What I am trying to do is create an automation that helps for me to be able to automatically move a sheet into another folder. I would only want that particular sheet to move over when my completion progress hits 100%. Not really sure if this is possible but it is worth a shot and was wondering if anyone could help me out…
-
Data Mesh Configs. on large sheets
Hello everyone! Are there someone, who has experience wih using DataMesh on large sheets? I'm in the middle of trying to figure out how I will make my intake sheet in DataMesh, so two columns will be updated automatically. But in Smartsheet Universitys course about DataMesh they metion that a configuration can only hold 10…
