-
API, symbols column and user locale
Hi, Let's say a german coworker that created a sheet and is using symbols. These symbols are in german as well, while my locale is in english. Using the API, i can't detect that the sheet was created with a different language and thus can't detect that "Grün" stands for "Green" and makes the update with the API quite…
-
Data Movements to Create Automated Workflows
Hi all, Quick question: We use qpulse as a quality reporting tool. We currently export data and manually enter it in Smartsheet from a .csv. I want to create a tool from that export, that drives a SQL import into Smartsheet, wherein the data from that import can automatically update my dashboards/reports/data source…
-
Keeping Track of Tableau Changes In Smartsheet
Hello, I currently have a sheet that links to various in-house Tableau dashboards: Is there a way for a user to click on one of the links, make changes to the dashboard, and then have Smartsheet show what changes were made? Ben O'Leary
-
Building A Test Package In SQL Dev That Writes To A Smartsheet
Hello, I am attempting to build a package in SQL Dev that takes data from a table in SQL Server and inserts it into a Smartsheet. For example, I have three lines of data in a table in SQL Server that I need to have added to a Smartsheet table. How do I go about creating a package that does this? I have never built a…
-
Column Specific Update Webhook Examples
I have successfully enabled a webhook to communicate with an Azure HTTP Trigger function which will run a Python script and perform other actions. This webhook only looks for row adds. I need a webhook for looking for an update to one column but don't understand the API documentation for scope and subscope. Does anyone…
-
Report Sorting
I've created a report, collating information from about 20 plans. I've group the tasks from each sheet together but I can appear to only be able to order them alphabetically, rather than actually order them in the same order the task would appear in the plan. For example my 2nd task is appearing first in my report. Anyone…
-
Unable to move checkbox while integrating
I am trying to integrate Airtable with Smartsheet using API connections. In the process, I want to move a checkbox column within Airtable to another checkbox column in Smartsheet. When I tried with the below code it throws an error of Unable to parse request. if(record.get('Calendar') != undefined && record.get('Calendar')…
-
Beware of "Input column index X is different from the first input column index X"
If you try to create columns in one bulk request, do not give each column its own unique index. All the columns need one common index (example: 1), which is the starting point (from left to right) at which the entire column set will be created. If you try to give each column its own numeric index (1, 2, 3) in the request…
-
How do you access user data once authentication is made in OAuth flow?
context: I integrated a Node.js Smartsheet Oauth flow into my Django app by having the login button in django direct the user to the /auth url on the Node server. Once the flow is done and user logs in through Smartsheet, the redirect URL from the Smartsheet dev tools takes the user back to the Django website. Objective: I…
-
How to "GET" from an xml file?
My company is using a helpdesk/support ticket/eForm program to receive requests, and then manually entering those tasks into smartsheet. The program will allow me to POST the data via XML at the same time as form submission. I am trying to figure out how to automate this so that the data will then automatically be passed…