-
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
-
Python SDK update_column syntax
Using the python SDK I am attempting to update the options list in a "Pick List" column type but can't seem to get the syntax correct. I keep getting the error 1008 Unable to parse request. My code is: ss.Sheets.update_column(4065220*********, 5852349******, {"type": "PICKLIST", "options": ["a", "b", "c", "d", "e"]} error…
-
=Count IF 2 Number Range
I want to set up a countif that counts all of the numbers between 10 and 1000. Every time i set up a formula it only comes back with 1 instead of counting all of the times the cell has a number between 10 and 1000. =COUNTIFS({Formal Grid Quote}, >10, {Formal Grid Quote}, <1000)
-
Attachments vs Discussion with Attachments
Am using below Smartsheet API to get all the attachments. It brings the attachments from attachments and attachment available under Discussion. No problem in that. smartsheetclient.Attachments.get_attachment(sheet_id, attachment_id) While deleting the attachments using the below API. Here the problem is attachments section…
-
API call for RowID
Hello, I am working on an automation where I need to get a row ID number. I'm starting with the unique value in a Row ID column called "Row", so I think I need to search the target sheet for that value and return the row ID number. I would like some help structuring the API call. The format of the unique number in the…
-
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…
-
How to send an actual attachment and NOT the link to the attachment
Is there a way to send an attachment to someone in the Contact cell and not the link to the attachment? I don't want to share the sheet with the resources as it has confidential information. When I do the workflow, it sends a link and the user gets an error that they don't have permission since they aren't shared.
-
How to get attachment names from one smartsheet to another?
Hi, I have attachments in rows in one of the Smartsheet. I want those attachment names into another Smartsheet. I want this process to be done automatically. Could someone please help me on this. Thanks In Advance.
-
Attempting PUT method on Reports "sourceSheets" field... Does anyone know what the API is expecting?
Hello! I am attempting to use the PUT method on a Report to update the source sheets, but cannot figure out how it wants the source sheets to be formatted.. Like what information do I need to put for each sheet in my array of sourceSheets? I am using Powershell. Here is my code so far: $token = <API TOKEN> $reportID = <ID…
-
Why is Smartsheet only adding one blank row instead of all the rows it read from G-sheet?
Hi, I'm trying to make a script from Apps Script to work with Smartsheet and I'm stuck. The script is to process some rows that need to be copied to a specific Smartsheet based on some filtering criteria, but after the script runs, we can see the following. Is there anything that might be preventing Smartsheet from pasting…