-
Using Bridge to update dropdowns
Hello, I am trying to update a dropdown in a sheet using values from a report using bridge, but am running into a problem where the array in Bridge is capped 10,000 rows. My dataset from the report is currently around 80,000. Below is my current setup. Is there different way that I could go about setting this up to capture…
-
Integrating Jotform via Zapier
Hi all, Wondering if anyone has had luck integrating Jotform and Smartsheet via Zapier. We would like to create an action where submissions in Jotform are "shuttled" as new rows to a grid in Smartsheet. Unfortunately Data Shuttle does not support Jotform (at least for us), but could a similar action be created via Zaps?…
-
Integrating Jotform via Zapier
Hi all, Wondering if anyone has had luck integrating Jotform and Smartsheet via Zapier. We would like to create an action where submissions in Jotform are "shuttled" as new rows to a grid in Smartsheet. Unfortunately Data Shuttle does not support Jotform (at least for us), but could a similar action be created via Zaps?…
-
Bridge - New Row to SharePoint list
Good morning, I'm working with Bridge and still getting used to the capabilities, and more importantly, the syntax. Perhaps this is not the best option as I am generally pretty good with code, and there is a lot that seems to be hidden or overly simplified. So my "simple" question is how do I set up a Bridge to add data…
-
Filtering values from collection file
Hi, I have a situation where I'm trying to create an intake form contain drop down filters that end users would select in order the division, region, county, state and related ID. My goal is for the initial selection being followed by an associated value throughout from division to ID. I can easily create drop down filters…
-
Bridge: Update a Contact Column Dropdown List?
Has anyone successfully used Bridge to update the dropdown values in a Contact List Column? I'm trying to modify a workflow that updates a Dropdown column - and it seems like it should work, but I keep getting this error (or something similar): I've tried formatting the source column as a Contact Column, a Text Column…
-
Issues with Fieldwire integration and reports made from those grids
My team uses Smartsheet for milestone task tracker and then Fieldwire for all things engineering drawings. When boots are on the ground, tasks are created in Fieldwire since you can tag drawings / portions accordingly. In the past six months, they introduced a Smartsheet integration where it can create and every 24-hours…
-
Dynamic View Not Allowing Temporary Sort
I have a dynamic view that is pulling from a report that contains two source sheets and does not have any default sorting. When I try to temporarily sort the DV by date, it loads and refreshes as if it is sorting the data, but nothing gets sorted. All of my columns in the DV are behaving this way. What is going on?
-
Is there a way to proactively include the three baseline columns in blueprint within Control Center?
The challenge I'm facing is that these columns aren’t created until the baseline is saved on the sheet—after it's already provisioned via SCC. I’d like to add them to the blueprint template sheet ahead of time so they can be incorporated into my profile data and made available for reporting. How can I do that?
-
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…
