-
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…
-
Zapier: Adding Rows and Attachments via gmail to Smartsheet
I can successfully get Zapier to add a row to Smartsheet when I apply a specific label in Gmail, but when I add an additional step of adding an attachment to the row that was just added, it always goes to the row below the one I just added with the Zap. In the setup where I specify a row to select to add attachment, I do…
-
DataShuttle Source
Hello, I am working on having SQL load a sheet into a folder on my OneDrive to load data into a sheet on a weekly basis. While using DataShuttle, I get to the Mapping section and it says, 'Please select a Source in order to see dropdown options,' but I've already selected my source from my OneDrive. Any idea what I am…
-
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…
-
Does anyone have experience with handling JWT data with Bridge?
We're using Google PubSub service to receive updates notifications and they come with JWT encoding in the web hook endpoint. Does anyone have managed to decode JWT payload in Bridge since we cannot run libraries in Bridge and there's no working Javascript to decode it. Thanks!
-
Resource Management: Can you submit approval by project?
In RMS (Resource Management by Smartsheet), each resource can submit for approval with the assigned approver for each resource. If we need to submit approval by project, can it be done? For example: I am assigned to Project A and Project B. I will submit the hours I have put in for Project A and Project B. Project A hours…
-
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…
-
Calculate with MONTH
Hello, With this formula I can not calculate the number of days if the Month is superior or equal to "10" =IF(AND([Mois fin]@row = "3", [Mois début]@row = "3"), [Fin incapacité]@row - [Début incapacité]@row + 1, IF(AND([Mois fin]@row > "3", [Mois début]@row = "3"), {DATE METRIC Range 1} - [Début incapacité]@row + 1,…
-
Desktop app for Macs
Is there a downloadable desktop app for MacOS? I am unsure as it is not easily find-able from your website, and I don't know whether it is a case that it is not available on my AppStore from my region (Hong Kong)?
