- Automatic Deletion
I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the data. They propose that a notification is received when someone fills out a form and the…
- Activity Log CSV Export - Bug
I just tried to export an activity log csv and I was sent an email to download a .zip (theoretically) with a csv inside. However, when I got the .zip there was no csv inside and when I tried to unzip I got an error message that said the zip file is corrupt. Anyone experience this?
- Image as map input
喂,是使用一个图像成为可能s a map to either click to input coordinates as x and y values or to plot the coordinates back onto the image? I've done lots of searching but can't find anything. I want this feature to mark locations on a site plan or equipment drawing. Not a Google map. AppSheet does something…
- 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…
