-
Moving data from row-level attachments into SS rows.
Hello! I recently received a request to build some form of "batch upload" process, where users upload a spreadsheet filled with contact data and submit it via form. We would then like to move the data from these row-level attachments into columns on another sheet, where contact information from all form attachments is…
-
Column Specific Update Webhook Examples
I have successfully enabled a webhook to communicate with an Azure HTTP Trigger function which will run a Python script and perform other actions. This webhook only looks for row adds. I need a webhook for looking for an update to one column but don't understand the API documentation for scope and subscope. Does anyone…
-
Can Smartsheet send a notification to a TEAMS channel that is private?
When creating an automated workflow- i want to send a notification to a TEAMS channel. It seems that it will only work if the TEAMS channel is set to "Standard". I am currently trying to get a notification sent to a channel that is "private".
-
How do you access user data once authentication is made in OAuth flow?
context: I integrated a Node.js Smartsheet Oauth flow into my Django app by having the login button in django direct the user to the /auth url on the Node server. Once the flow is done and user logs in through Smartsheet, the redirect URL from the Smartsheet dev tools takes the user back to the Django website. Objective: I…
-
Smartsheet ODBC Add-On
Hi - I hope everyone is doing well. Is there a Smartsheet add-ons that allows bi directional ODBC connectivity with other applications? We would like to refresh the sheets in Smartsheet via ODBC connections from various applications. Thanks in advance.
-
Published Dashboards & Attachments via One Drive
Is anyone else having issues w/ the new Dashboard UI? This started no more than a week ago. I maintain multiple published dashboards and share them to subcontractors outside of my network. I attach documents from One Drive to the Dashboard using the shortcut widget w/ One Drive. The documents I'm attaching are PDFs & I…
-
Double Entries on Pivot Sheet Returned via Pivot App
I have a pivot table set to update immediately via Pivot App, but whenever I add to/refresh the data in the source sheet, the pivot table will often reflect duplicate rows/values. I have a source sheet with individual lines of data for a resource's time on each project he/she is working on. In the returned pivot sheet,…
-
Success stories for Smartsheet - 10,000 Feet integration?
The Smartsheet community is pretty established, but curious how many companies are also successfully using 10k'? ... there aren't many topics that emerge here for that product, so I thought I'd ask the general question. Our agency has been working with both tools for about 6 months, and I'm glad to see us getting more…
-
How to move information with a workday function?
I work for a bath remodeling company and we have installers with level 1, 2, 3 based off skillset. I need a way to plan availability based off the amount of installers we have and their levels. Right now the date column reads, =WORKDAY(TODAY(0), Label@row) and this allows the dates to update automatically. I originally had…
-
Dashboards
Am I the only one who truly hates the new Dashboard UI? Since the new UI was introduced, it takes me at least 5 additional clicks and much more time to create a new dashboard or modify an existing one... I used to be able to "Save as New" an existing dashboard and modify it for the project, while keeping the layout. With…
