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.

Is there a way to "get row number/id" using a row attribute?
I am processing a set of parent/child rows via a set of Alteryx workflows and I have the possibility of adding/updating rows to a SmartSheet grid in the process via the download tool / SmartSheet API. Trouble I am running into is that the original row number obviously changes if I add a row - currently doing a GET each…
SmartSheet API - Node.js SDK addRowUrlAttachment
What is the request body syntax when using the addRowUrlAttachment method in the Node SDK? The API documentation only shows an example using the addRowFileAttachment method.
API for linking MS Excel to SMARTSHEET
Greetings I am handling a number of projects and making Gantt charts to track their progress. The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem. I…
Used in formula on: <unknown sheet>
Is there a way to see who the owner of the <unknown sheet> is? I'm have multiple sheets with data that is used for various metrics. I am currently looking at revamping those sheets but I have several columns that show: Used in formula on: <unknown sheet> I'd like to see who the owner of the unknown sheet is to notify them…
How to address column restriction error and value does not conform to req for PICKLIST?
Within Data Shuttle, 4 days ago I started having Data Shuttle workflows that would not work. I am trying to upload data from an excel sheet that is housed in one of my other Smartsheets. The workflow error states "Unable to update row in target sheet : CELL_VALUE_FAILS_VALIDATION: The value for cell in column 9950538889…
smartsheet report to Salesforce connector
Has anyone completed smartsheet report data to Salesforce using the connector addon. Any suggestion show this could be done. I know it can map a sheet in SS to SF but not sure about reports in SS to SF.
Automate printing labels
Is there a way to automate sending smartsheet data to another app or program to print custom Labels? Either with a button or maybe a checkbox in a "ready to print" field. Ideally this would be per row once info has been entered.
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
Retrieving Strikethrough Formatting with Python SDK
Hi all, I'm using the Smartsheet Python SDK to fetch data from my sheets. While the data retrieval works well, I'm encountering a limitation where cell formatting, specifically strikethrough, isn't captured. Currently, the retrieved data appears without the strikethrough even though it's displayed that way in the sheet. Is…
Can you help me make or identify a template for my project?
hello, I am an instructional designer at a large community college (my license is through the college). We do not have workflow or dynamic view or datac connection options licensed… no extras as far as I know. I manage some complex sheets but I have not yet mastered how to create or use templates or create a project that…

Popular Tags

Trending in API & Developers

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…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!

API & Developers

Discussion List

Categories

Popular Tags