-
Creating price tickets
Would be grateful for any guidance please. I'm looking for a way of producing sheets of price labels including a barcode that would be generated from a smartsheet. I can get all the relevant data into one smartsheet however I have been struggling to come up with a way of creating a PDF that would contain the price label…
-
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…