-
Is there an API for automating parent/child indentation from a form?
Hi! I am trying to create a smartsheet that automatically indents child rows from a form submission. Right now, there is a main "parent" form, then a linked "child" form that creates a new row under the first, but they all come in at the same level of hierarchy. I'm looking to automate the indentation because there are…
-
Webhook events
My company is looking for a way to export a project's data (including attachments) when it is checkmarked as complete in our projects list sheet. We would like to append this information to an excel spreadsheet or a google sheet. The workflow that I had in mind is that when an order is checked as complete, it triggers an…
-
How to ensure you receive all webhook callbacks when multiple changes saved to smartsheet
When a user changes a picklist value in more than one row and saves their changes, I only receive the status change callback for the last row. For example, if a user changes a picklist value in rows 2 and 3, I will only receive the status change callback for row 3. What steps can I take in order to receive all callbacks?
-
Weekly automation in Smartsheets
Hi, I want to automate a column in my sheets. Right now, I have the column connected to a form where people can either free type or click on the drop down. On Monday of each week, I want the drop down list to be updated to include all the free typed inputs. Is this possible and how do I do it? Thank you.
-
Smartsheet won't connect to Zapier
Smartsheet got disconnected from Zapier and it won't reconnect. Has anyone run into this issue? This is the error message I get. Zapier could not connect to your account. The app returned "Invalid hash value. The hash provided did not match the expected value.".
-
Is it possible to Extract Information (Pull) from a Smartsheet to load directory (csv, Excel...)
We have a process in place where we would like to integrate data collected from a Smartsheet from into another solution to enrich records. Smartsheet would only be part and we are looking for an automate and PULL information from a specific Smartsheet into something that either could be loaded into Excel. We are trying to…
-
HYPERLINK API
We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyperlink manually for each row is a terrible ordeal. It would be great if you add HYPERLINK("URL", "Text")…
-
Use smartsheet to autofill / export excel spreadsheet
Hey! Can anyone help with this question: Similar to the "form" function in smartsheet, I can generate a survey-like webpage where users can fill in info for different columns. On the other hand, users want to upload a spreadsheet with e.g. 10 records. My target is to apply the info user filled in in the first "survey"…
-
Save button is not enabled after new row is added in Smartsheet via Bridge
There is a new row added in the Smartsheet via Bridge after adding a row in another sheet. Though a new row is added successfully, the Save button is not enabled to trigger the "Row Added" event in Webhooks. Please let me know how can i receive the "Row Added" trigger once the row is added, So i can create new work item in…
-
Reports not updating, sheets not updating
HI, for the past 24 hours nobody in our team has been able to get reports to update. We've tried all the normal things, saving, refreshing, changing owner/admin/editor settings and nothing will make the reports to reflect the sheets that feed into it. This is becoming a real problem that affects the whole company, could…
