-
Submitting a row to two sheets broken by SDK updates
We have a form on our site that adds a row to two sheets in Smartsheet. This broke in June at which time the form added a row to the first sheet, but failed in the API call to Smartsheet in adding a row to the second sheet. Example Code that submitted to the first sheet (this was not affected): protected void…
-
Jira Connection for Sprints (Not Issues?)
With the Jira Connector, is it possible to pull all the sprints into Smartsheet based on the sprint as the unique item/key, not the individual issues? I'd like to better see all our sprints across all our teams and report based on the most recently closed sprints in a given project. Since I can't query on the most recently…
-
l
l
-
Update VIA API not showing updates
Hello There Super Noob to Smartsheet APIs. I am updating smartsheet, with Powershell, a Test Sheet sending simple sample data. It shows that I have added multiple row, in the test sheet, but it isn't showing the data even if I refresh the sheet. I have no Idea whats going on.
-
Excel Formula Error
Hi All, I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas: =COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1)))) The "[Listing Key]2:[Listing Key]20" reflect the chosen cells to crunch the formula. Attached is a…
-
Report Frustrations from SmartSheet
I have been using Smartsheet now for about 2 months. While I love it for so many reasons, I am frustrated too. I love being able to run the reports, there are so many great filters......why don't they just allow a function to add totals to the reports. Hence, when management asks me to report the sales numbers based on…
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
Adding Task name to exported comments
Hello, when I do an export to PDF I get the comments on a separate page, which is all fine. However the reference on that page to the gannt chart is the Row Number. Is there a way of adding the Task Name to this comment page? The reason is that it can be a bit confusing to scroll up and down to reference the row and…
-
Creating a Temple for Router Configrations
I have an existing sheet with a lot of information in it. I would like to create a template to populate based of the information in my existing sheet. Then I would like to be able to print or export the information to create a router or switch configuration template. Sounds easy enough but have never done this and would to…
-
S-curves
Hi everyone, Someone knows if it's possible to make S-curves with Smartsheet to track project progress? If it's not, have you found any convenient way to make S-curves out of your Smartsheet data? I mean without copying manually the data to an excel or MS Project file. Best, Jason