Product questions?
Ask it here! The community's got your back.
Discussion List
Learning about Pivot App
This discussion was created from comments split from: Pivot App.
How to use Smartsheet syn data to google sheet at Real time
I want export or data in smartsheet to google sheet at real time.
Dynamic view conditional column hide logic in details panel not woorking
I would like to use relational column logic and it is suppose to work in dynamic view form. I want dynamic view input form to show fields based upon option selected in preceding field. For eg: I have a field "channel" which have options "Email" and "Social". now, when i select "email" in channel form should show "email…
Data Shuttle Offload from Smartsheet to Google Sheet - Append vs Overwrite
Hi! I am offloading data from a smartsheet with filters into a Google Sheet and I would really like to simply append any new data rather than overwrite. We are using the offload to create a task list where we wll add a notes column to the right, but since it overwrites every offload, we can not use it in that manner. Is it…
Remaining Working Days Calculation
Howdy, I have been looking at various community posts, and I am still unable to find an answer. COLUMN D is DUE DATE COLUMN E is WORKING DAYS REMAINING Row 1, Column D date is 9/29/24. What is the formula I can use in Row 1, Column E that I can copy down the rest of the sheet?
Slack Integration
Hi All, I know we can integrate Slack with Smartsheet to send notifications to Slack. I would like to know if it is possible to use information in Slack Workflow to update Smartsheet automatically. This would involve adding the details of the Workflow into a new row in Smartsheet whenever a new message is posted in a Slack…
Joining Data b/t an Intake Sheet & Summary Sheet
I am using Smartsheet control Center and have an Intake Sheet and a Summary sheet. I also have a Profile Data Sheet in my project template. The Intake & Summary sheets have a project # to join data. I'm wondering what is the best way to join data to display information on a report? 1 - Intake sheet populates a Project…
Control Center & Publish Embed Code
I am creating a Control Center project that will create attendance reports that will live in Smartsheet. (one for each clinical course each term). Part of the provisioning process would include an automation that would send the clinical lead the embed code for the sheet so they can place it in a page inside of the LMS…
Bridge: Plugin Error INVALID_DATA
Hi, I am creating a workflow to update a dropdown automatically. It gets the data (array), but I get the following error when updating the column with the array data. Does anyone know the reason? Thank you
How do I use Smartsheet connector in Power Apps?
Hi, How do I use Smartsheet connector to Insert Row in specific Sheet? Documentation is quite poor and don't know how to pass values properly. Code that I use is below. How do I fix it to make to make it work? Smartsheet.InsertRow( "192045464213123"; { [ { "columnId": 4266183311445892, "value": "TEST", "displayValue":…