-
Field Employee time tracking software that integrates with Smartsheet?
I'm looking for a time tracking solution for field employees that integrates with Smartsheet. In our organization we have a master project list sheet that compiles project data for all of our active projects. Our field installers are currently logging their time using T Sheets, they're clocking in/out as well as selecting…
-
Conditional formatting not sticking to exported PDF
Hi, I have a report that looks perfectly fine when viewing in Smartsheet but when exported to a PDF it throws in a grey fill. There is a conditional formatting that specifically says if the "Resource name headers" column is blank, keep that cell white - and it's a higher priority than everything else. Why is this happening…
-
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…