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.

Summing columns from multiple sheets
Hi, I have multiple sheets managing separate projects with similar columns. I would like to sum the data in a particular column across all sheets to get a total number for the dashboard in the Metric Widget. Is this possible?
Tableau Integration with Smartsheet
Hi Smartsheet Community! I know there is LiveDataConnector available to pull Smartsheet Data into Tableau, but is the reverse possible? I want to pull Tableau data into Smartsheet for one of my Project. Any help appreciated!
Form Generation
I tried so much but not able to get option to map in the highlighted area, can anyone help?
To get the contents of a column and apply filter to the contents
Hello, I am new to Smartsheet API. I am using Python API. Is there a way to get the contents of a column in something like list. I can get the Column name/ID but unable to lists out the contents of the column.
Error 1012: 'Required object attribute(s) are missing from your request: values.'
I'm having difficulties with the AddRows method in Smartsheet's C# SDK. I have been getting the error code 1012 with the message 'Required object attribute(s) are missing from your request: values." I have seen others post similar issues but with 'cell.value' as the missing attribute. In my case, what is 'values' supposed…
VBA: Push Button in Webform code
All: this is to share/record a way to push the submit button in a smartsheet webform using vba. I share this because I spent way more time trying different options posted on different websites than I would like to admit. Dim IE As Object Set IE = CreateObject("InternetExplorer.application") IE.navigate…
Automated emails
Hi, Is it possible to change the "from" address when sending automated alerts/update requests? Or is it always the default SmartSheet address? Thanks
Would it be possible to add multiple request approvals in one approval request?
This would greatly reduce the number of automation work flows for a given sheet. I want to do this (instead on multiple work flows) so I can get and see individual responses in separate columns.
Jira connector with tracking Epic % complete by epic name
I'm trying to show the % complete for epics that are in progress but having trouble getting this to work. I have the Jira connector already setup, mapped to a summary sheet with formulas, and finally to an executive dashboard. My ask is how can I pull in the epic name field from the source sheet connected to Jira, onto the…
Error Code 4000 "Unexpected Error"
I am getting error 4000 when trying to write to a sheet using python. All it says is "An unexpected error has occurred. Please contact Smartsheet support at api@smartsheet.com for assistance." I have successfully written to other smartsheets using the same code so I do not think it's something I am doing wrong on my end.…

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