Product questions?
Ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Disable notification on add Alternate email and Set primary email via API
Hello, We are adding Alternate emails and then setting Alternate email to Primary via API, on both changes users get non-actionable notification i.e. "Your Primary Smartsheet email address has been changed etc." Is there any way to disable these notification via API or temporarily disable all notifications for mass change?…
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?…
smartsheet API key is not able to fetch data from the smartsheet having MFA.
I am not able to fetch data from the smartsheet using API key which is having MFA. I am getting an error - "This action is restricted by an MFA Policy. Please reach out to the workspace admin for any questions.". How I can resolve this issue?
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.

Popular Tags

Trending in API & Developers

कुकू fm से पैसे कैसे वापस करें?
कुकूएफएम मई को स्वचालित भुगतान रोकने के लिए, उनकी ग्राहक सेवा हेल्पलाइन नंबर O8016/43/8256 // संपर्क करें और ऑटो-पे को अक्षम करने का अनुरोध करें।..
How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…

API & Developers

Discussion List

Categories

Popular Tags