-
Data Shuttle Keep Data in unmapped column
We are using data shuttle to upload from a csv file once a week on Mondays. Throughout the week we have an assigned to column (that is not in the data source file) where people assign themselves to tasks (so different rows in the source file). They might not get to the task that week, so when we update the the data on…
-
Reverse Geocoding
I am using a form with the pin drop to track sales employees in person visits / cold calls. The return value in my data sheet is the location coordinates hyperlink that takes you to Google Maps. Is there a way I can extract the address information from the coordinates into a separate column on my sheet? I have an…
-
Knowledge Base to Onboarding
I am setting out on a path to utilize Smartsheet as a Knowledge Base platform for our department. Just as the brain is made up of many parts and connective tissue, so are the functional roles of the business. Smartsheet does integrate video, SharePoint and Lucidchart which conveniently reduces Phase 1 setup. Phase 1 -…
-
Docusign Formatting - Box/Border around imported text fields
I'm pulling info from Smartsheet into my Docusign PDF template and can't get rid of the box that Docusign puts around text. I'm trying to pull Smartsheet info into a table in the PDF so I'm ending up with a box within a box. Is there any way to get rid of the box/border Docusign wants to put around text fields?
-
Update SMARTSHEET using Power Automate
Hello, I have an updated Excel file, and I would like to transfer new rows of data using Power Automate. I see the ability to go from SMARTSHEET to Excel, is there a way to go from Excel to SMARTSHEET? Thanks, Shahara
-
How to combine cell change notification and Data Shuttle
Hello Community, does anyone has an idea to solve the following problem? I have a data shuttle running every night, pulling information from an excel spreadsheet into a sheet (let's call it sheet 1). Do to the fact that there is no unique identifier in that Excel sheet, Data Shuttle completely replaces all the entries in…
-
SmartSheet Jira Connector
Hi Team, We are trying to integrate SmartSheet into Jira, however when looking at "Jira Connector by Smartsheet" I see the following: https://marketplace.atlassian.com/apps/1215530/jira-connector-by-smartsheet/version-history We are running Jira Cloud. "version":"1001.0.0-SNAPSHOT", "versionNumbers":[1001,0,0],…
-
Why Portfolio Summary Sheet displaying duplicate rows?
I created a blueprint in Control Center and all was working fine until I updated some columns (adding more values for drop-down list and changing a column to a formula column) in the intake sheet. I think I must of done something that messed up the blueprint because now new provision projects are showing up twice on the…
-
Default view card or calendar for Teams integration
Hi there, I attempted to see if there was a solution for this out there, but no such luck. Hoping this group may be able to help... I recently integrated some sheets to a Microsoft Teams channel. The sheets in question when shared in Smartsheet are Card view or Calendar view rather than the standard grid. When integrating…
-
Document Generation/Dynamic Views & Conditional Formatting
How can I set up a generated PDF document to carry over the conditional formatting from my grid? Can the Dynamic View also show the conditional formatting applied to the grid? This works for reports but I haven't been able to figure out how to set the document or view up to show the conditional formatting in the grid...…