Smartsheet SDK: Cannot find column
Hi, I have run into a rather annoying issue. I am currently writing a sync tool, which will add a column to a sheet, and write a cell value thereafter. I am using the smartsheet search feature to find a specific value, and then I add or update a specified column. However, the issue I am running into is that a few of the…
Would i be able to share a folder?
I manage a project with several sub-projects. Is there a a way to share this?
unable to access Smartsheet via my work email
Hi All, I am getting this error while trying to access our work Smartsheet link .. Any idea what is the problem and how to fix ? opensaml::FatalProfileException The system encountered an error at Mon Aug 16 08:59:58 2021 To report this problem, please contact the site administrator at https://www.smartsheet.com/gethelp.…
Attributes not present in response
Hi team, I have couple of queries, could you please address those? Query 1. While fetching all the users, I am not getting groups associated to the users in the response. url: https://api.smartsheet.com/2.0/users?include=groups Note: I have referred the documents to include groups and I am sure that the users are…
Smartsheet API parentId location specifier doesn't work?
I have a function used to make parent-child relationships in smartsheet. The child_df contains the row and parent info, when I call update rows, it reads my row ID to update (row.id) and if I pass in the argument row.to_bottom = True it also works, but it stubbornly doesn't assign a parent ID when I pass parentId into the…
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…
API Updating Row Format
I was trying to find some documentation on the format string and came across this forum. https://community.smartsheet.com/discussion/13111/update-row-background-with-api I'm trying to update the format of an entire row ( mainly just trying to update the background color of an existing row ). In the forum above it says to…
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…