-
Move/import comments
I have comments on a sheet that is no longer going to fit with our structure and I would like to move the comments from a row on one sheet to a row on another sheet. Is there any way to move comments from one row to another? Any way to import comments to an existing sheet? I exported the sheet to Excel and the comments are…
-
Creating a Master Sheet Composed of Dependent Dept Sheets // Sheet Linking // Sub-Sheets
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here is that while only I may have access to the the "Company All" the dept heads have access to their respective Department…
-
C# API Add Records from MS SQL Server
Hello, I'm trying to get records from a SQL table into Smartsheet using C# and ultimately SSIS (via script command). I'm stuck on how to add the rows into Smartsheet. 1. I want to add the rows dynamically without having to code the column id. I see that there is Bulk Operations but very little documentation for it. This…
-
SmartSheet - JIRA Connector
I'm using the JIRA-SmartSheet connector to export data from JIRA into Smartsheet. I use this frequently with a lot of success. However, I just noticed something that seems a bit odd. Sometimes, I will export data utilizing a workflow with a filter of 'Labels include...x, y, z' so that my sheet will include only a limited…
-
Feature Request: Include Attachments (Photos) in PDF Export
When printing a sheet, or exporting to PDF, attachments are excluded. I can understand excluding a variety of large and complex attachment types, but how about including photos? Discussions can be included and are included, with row references, at the end of the sheet. How about doing the same with photos? Print them in a…
-
Send csv via email to update a sheet
Is it possible to send an email (with a csv attached) to automatically add rows to my smartsheet? My internal system has the ability to send csv files via email with latest changes - I want to remove the manual copy-paste inbetween step. Cheers
-
Salesforce Connector currency conversion
I am trying to pull a report using the Salesforce Connector with currency converted to USD. I know the field names, but they don't seem to be available for the Opportunity object. I checked and I do have permission to view and edit the fields in Salesforce.
-
Auto Filling a cell from data in another samrtsheet
Good afternoon I am creating a bid invitation sheet and need to list GC bidders per each job (row). * How do I create an autofill for these cells based on a directory I have created? * and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is…
-
Printing and exporting to PDF
Is there a way to add more page size options in the print and export to pdf forms? Custom page size? Or is it limited to the list of available options? Thanks in advance
-
Unable to export selected columns to pdf
Has anyone noticed that the "options" button on the pdf export sheet is not available? this is the button which allows you to select which columns to export thanks Neil.