-
How to import data from another sheet
I am very fluent with Excel but find that it doesnt work completely the same with Smartsheet. I am trying to import data from another Sheet i.e. Sheet1 A1= 200 Sheet2 A1='Sheet1'!A1 How do I do the same thing with Smartsheet and then hide the formula?
-
Download Sheet data via API
Is there sample code in C# to download data from a sheet to a local drive? for some reason when I use the API and try to read the number of rows I always get null values long? numRows = tmpSheet.TotalRowCount; Thanks in advance
-
Reports and Pagination
Hi! I've written a google script that mirrors a smartsheet - it checks hourly and syncs the google sheet to reflect the latest info in smartsheets. It works great with sheets, and all of the rows populate correctly. However, when I switch the target to a report, only 100 rows will sync. When I switched to looking at a…
-
Update row Webhook triggered when filtering rows...
The update webhook got triggered if I delete rows and also when I filter in my page. Is there any way to avoid it and get only webhook when data changes, not if a row is filtered, deleted or moved? I'm working wht zapier, and I get a lot of "false" updates due this issue.
-
When will the API get some attention?
I'm using the smartsheet library, and it works pretty well, except that checkboxes always return None, no matter the value. I submitted a bug to the repo on github, and linked it to some other folks that noted the same problem on StackOverflow. For the tool I'm trying to build, I really need that feature to work, or at…
-
API to apply conditional formatting
I am not able to find how to apply condiional formatting via API. I have various sheets that I want to update all at once and apply different conditional formatting without having to do it via the interface manually.
-
Column name/header
Feature request It would be great if I was able to format my column name/header. Specifically to wrap text so I can see the entire label for narrow columns.
-
iframe compatibility mode
Anyone got ideas on getting the published read-only iframes to work in IE's Compatibility mode? Using IE10 for an intranet site, but the Smartsheet in the iframe just continuously reloads
-
Capturing Row History Information
Is anyone capturing row history information via the API? I'm interested in knowing how best to do this in order to understand the "history of events/actions" for a row business item. Thanks, Rick
-
Live Data Connection enabled for GE account?
Is the live data connection enabled for the GE account? I've been trying to access it as described in the help guide without sucess. Regards Christopher
