-
Attempting to convert data from check boxes to Multi Select Dropdown
Thank you in advance for any help you can provide. Since the Multi Select Dropdown option was not around when we created our form, we used a variety of check boxes to gather the required data via a form published on our website. Now that the Multi Select Dropdown is an option, we would like to migrate that data over to a…
-
Using Microsoft Flow to Send Email
Hello, Currently Smartsheet doesn't allow me to send an Alert with an attachment. The context of this is for a travel spreadsheet, when someone enters their itinerary, it will send the person an email with a standard email containing an attachment of various do's & don'ts. I think I've got my flow set up ok but I'm…
-
Creating workflows for repetitive tasks in Smartsheet
Hi How do I automate the workflows in smartsheet for repetitive tasks? For example Scenario 1: The issue has been raised by Testing team - which goes to the Development team, they modify the code, Testing team tests the modified code - if the issue is resolved, the issue is closed, if the issue is not resolved the cycle…
-
Export Dashboards
Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly recommend the option to export reports and dashboards (Word, PowerPoint, etc.) directly…
-
Add Image (via binary not file) as attachment (and in cell)
Hi, I am using the C# API to interface to Smartsheet.... I can see how to add attachments and images in cells but these only accept a file name as a parameter. My images are stored in a database, is there a way to upload the images binaries instead of from a file name ? thanks Dave
-
Unable to update a Summary field of type DATE using the C# SDK
Hi Smartsheet Community! This is my first post and I hope not to scare you away. I've been finding the community amazingly helpful in everything I've been doing so far. Now I'm blocked and I hope someone can give me a hand . I'm trying to set a Summary field "Project Due Date" across multiple sheets.This Summary field is…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Integrate with Bank Feed
Can I integrate a sheet with my bank (Lloyds) to automatically download new statement lines every 30 mins or so. I have to login to my bank and copy the data across all the time and would like to automate it if possible.
-
Live Tracking User Metrics Using Power BI
Hello smartsheet Community, I want to track company smartsheet user metrics such as the number of users, number of sheets, user types, etc. automatically using Power BI. Currently, I am exporting the user and sheet access reports and having to combine them into a single view before displaying the data in a meaningful way.…
-
[PYTHON API] Adding an new row with date column
Using the python SDK, I'm having trouble adding a new row to a sheet where one of the columns is a DATE column. For ex, doing: cell.value = datetime.datetime.now() with the column type as DATE doesn't assign anything to the column, and the request comes back with an error since the cell.value is empty. If online I switch…