-
Match or VLookup?
I cannot figure out how to cross reference two excel documents for changes made from one day to the next. Long story short, our EDI process is not working at this time. Until it is up & running, our csr is required to manually review each page for changes from the previous day. It is so time consuming but until EDI is up &…
-
Smartsheet/Google Form Sync
We created a sync between a google form and a smartsheet that records promotion requests. This sheet is used multiple times a day to record these requests. The sheet stopped syncing on August 14 and the team cannot figure out why the sync stopped. We researched the community and help for potential issues. Do you know of…
-
Fit Gantt to paper
Hi, Pretty please. even I do have set the granularity of the project to Quartes (see picture 1), when I tried to print it, or make an export to pdf, the Gantt is still in days. How the hell do I change it? There is nothing about the view in the print options :( thanks a million lukas
-
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…