-
Merged: Populate sheet when attaching PDF form
This discussion has been merged.
-
I am trying to manipulate my SUMIFs Formula
When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to use 1 reference and multiply it by 0.25 or 0.5 in the first "Range" category so =SUMIFS({Spend} * 0.25, {Phase}, "phase 1",…
-
SmartSheetAPI PUT
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
-
Assistance Needed: Summarized Report Not Available After Exporting in Different Format
I have created a report in Smartsheet where I grouped certain data and summarized it to obtain the total sum of the numbers. The results are accurate, and I am satisfied with the outcome. However, I have encountered a problem when exporting the report to different file formats. The summarization functionality does not…
-
Copy & Duplicate pack of sheets/Folders
Hi , I have number of sheets to collect data periodically on monthly basis with own automation/task and work flow and many of sheets are linked and reading data from source sheets . The above folders/sheets i create them every month using template function creating the sheets , and linking them again / rename it every…
-
Upload Thousands of Excel Documents to Rows
I have been building a workspace for inspection tracking. Before this we were utilizing an Excel doc that would use a macro to create a new Excel doc for each inspection with the information that was entered. There are 2332 excel documents. The information in each doc are not in individual columns. The filenames are Asset#…
-
Exporting Sheets & Forms for a deliverable product
**this is cut from a support email thread I've been on for several days.** Replying to this instead of the previous thread. Backing up my sheet did not have the attachments included as described in the "help" ticket. Please advise on how to make this app work in a proper function to export all information and necessary…
-
Missing columns on Excel Import
I am trying to import an Excel sheet. I have followed all of the steps carefully and each time I try to import, only the last (rightmost) columns of the sheet are imported. This leaves about 10 columns missing. The sheet has 2200 rows but the original sheet does not exceed the size limit of 50MB. Is there something that I…
-
Loading SQL Data into Smartsheet
Hello, Is it possible to set up a connection between Smartsheet and SQL Server with automatic updates? For example, if I have a SQL query that updates daily, I want to be able to have a Smartsheet table with the same data that also updates daily alongside the SQL component. Is it possible to accomplish this without the use…
-
Updating Smartsheet from external sources
I have a task list (for want of a better term) that was made in SharePoint and shared with many users. They make updates. I then export to Excel, import to Smartsheet and do what I need to to make an informative report. I can't remove the SharePoint element from this process. I need a way to update some of my information…