-
C# API Add Records from MS SQL Server
Hello, I'm trying to get records from a SQL table into Smartsheet using C# and ultimately SSIS (via script command). I'm stuck on how to add the rows into Smartsheet. 1. I want to add the rows dynamically without having to code the column id. I see that there is Bulk Operations but very little documentation for it. This…
-
Curl GET request mixed results
Hello community, Just getting started and trying to leverage Curl to proof a few things out. When I issue the following example command, I get a list of my sheets successfully: curl -X GET -H "Authorization: Bearer " "https://api.smartsheet.com/2.0/sheets" When I issue a more specific command listing one of the sheet ID's…
-
Smartsheet API - document generation and attachment to row.
Been struggling a bit with recent smartsheet api development and was hoping for some insight as to how to handle the following situation: To bypass the restriction of 5000 rows per sheet, I'm developing an app using NodeJS sdk that will run on a scheduler in the following fashion: If row count is 4500, next time this app…
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
Looking for a Guru to Build a Smartsheet + Quickbooks Solution
Hi I have a small engineering company 15 people that has not been able to find a real good Portfolio management solution so am considering creating my own with Quickbooks + Smartsheet. I use Smartsheet for managing commissioning projects so would expand this to include all of the 125 projects we currently have on the…
-
workflow automation
Are you considering to incorporate workflow automation to Smartsheet ?
-
Sharing a Folder
good Morning i have a workspace with 3 differen Folders. Is it possible to share each folder with differen people instead of settin all sharers at sheet level? Regards
-
Form Search and Auto-populate values
Hello, I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form and enter a key reference…
-
Living Graphing Solutions to Embed in Smartsheet Dasboard
Hello I am looking for advice on the best tool to extract data from Smartsheet to a third party graphing service and then embed the 3rd party graph in a smart sheets dashboard. The two options I can think of are the !. Live Data Connector to Excel or Tableau 2. Power BI desktop Is anyone familiar with these methods or…
-
Clone sheet and reports between accounts
Hi there, I'd like to take a sheet and some reports that operate on that sheet, and clone them over to a new account programatically. I'm able to share the items, copy them, and then un-share them programatically, but the reports then point to a non-existing sheet. Since I have quite a number of reports I'd ideally like to…
