-
Calendar app filter
Hi there, I create a data sheet that connect to calendar app. I have a column with checkbox. is there a way that if I check the box in that column the data on that role will show in calendar app thanks, Jess
-
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…
-
Conditional search and return
My "Start" column has dates for each row; the "Primary" column has ~20 unique values and the sheet has ~80 rows with no parent rows; the "Task" column is mostly unique in each row instance. I am trying to return the minimum "Start" value to an "Order" column based on some keywords in the "Task" column for every unique…
-
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…
-
Formstack pdf returned to Smartsheet
Our current setup is Smartsheet information to Zapier to Formstack which emails the pdf to us. I would like to have the form sent back to Smartsheet, to cut out the email, & according to Formstack (Overview tab) it is completing this process however the form does not appear in my Smartsheet and I do not find that it has…
-
Sharing Recommendations and Limitations
I'm rolling out a new process with a client and constantly finding areas where I need to use a work around, only to find that solution won't work in another aspect. For example, I have one sheet with sales data that needs to be updated constantly by the sales team, however, I don't want them to have access to the sheet,…
-
Webhooks vs Built-In Automation
I know that automated workflows in smartsheet won't take place if the trigger is a change on a cell link. Will the same happen in the case of when a webhook is triggered? Will a webhook send if the trigger is a cell linked column?
-
API Load Error with Python Executable
I have created a python script in PyCharm, the file has been running with no issues. I converted the file to .exe using PyInstaller and auto-py-to-exe but with both methods I receive the following error after running the .exe: "Import Error! Could not load api or model class folders." A screen shot of the command line is…
-
Dynamic Views & Dashboards
Can you add a dynamic view to a dashboard for easy access?
