-
Importing Excel Data into a template
I have created a template with all of the appropriate columns, workflows and filters that I need. I have a 4900 row Excel spreadsheet with my data. I would like to import the Excel spreadsheet into my template. I can copy and paste, but since the limit is 500 rows at a time, it takes time. I cannot seem to find a way to…
-
Converting project links from report to hyperlink in Power BI
I have a report that I am using to feed into a Power BI file. There's a column in the report for a link to individual project sheets, but this column shows up at text only in Power BI (For example, a clickable hyperlink to "Sheet A" in Smartsheet shows up as "Sheet A" as text only in Power BI). Is there a way to get the…
-
Jira Connector only allowing one project to one sheet
Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is collating all enhancement requests (using a web form as a front end) which will place enhancements into the relevant Project…
-
automate a download of a sheet
Dear Community: Please be gentle...I am new to the community. Our application uses forms to have people add row to various sheets. On one of the sheets we need to upload to one of 1000 systems as people continue to add to the sheets. I thought I could create a rule or action that would allow me to automatically download…
-
Adding Matching Barcodes/SKU's from a transfer sheet onto a master Inventory sheet
Hello all, I'm new to smartsheets and working on setting up a barcode based inventory management system for the warehouse I run. I feel like I have the transfer sheet up and running just need to get all of that information to condense onto my sheet. Would someone be able to point me in the right direction or find what I'm…
-
Integrate with Microsoft Access
Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
-
Mass file transfer from One Drive folders to Smartsheet Attachments
Hello, I'm wondering if this is possible through the One Drive connector, any automation tool, or API. I have roughly ~1,000 folders in OneDrive, and the folders are named by client ID. Each client has 1 row in a smartsheet tracker, and the primary column is the client ID. The goal is to have all of the attachments in each…
-
Smartsheet - Azure DevOps integration
Hey guys, I'm trying to create a connection between Azure DevOps and Smartsheet but I'm having a lot of issues with it. Has anyone ever made a two-way connection between the two? Especially being able to update an item in Azure when a row is updated in Smartsheet (and vice versa)? My goal is to be able to update fields in…
-
Ability to amend 'sent from' email address to personal email for "Email Shared Users"
Regular update notifications are being sent to the Shared Users of a very busy Smartsheet. As such, our client has requested any emails that require immediate attention (not just standard updates) be sent from a personal email account, not Smartsheet. Is there a way to export the Shared Users email information so it can be…
-
Is there a way to migrate external references?
Is there a way to migrate external references from one sheet to another from the 'Sheet Reference Manager' (Right Click Cell -- Manage References... -- Cross Sheet References)? Or would it be a manual task to create references again. Thank you.
