-
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":…
-
Can Power Apps use the Smartsheet connector to update cell values in a Smartsheet?
I wrote a Power App that accesses the data in Smartsheet cells. A Smartsheet contains a table full of Rows. And each record in that table includes some data and then a table with the custom columns/cells. So you can't just connect to a Smartsheet. Instead, I loop through the Smartsheet and build a local collection that…
-
Outlook Add-in Reports
I would like to add emails using the outlook add-in to a Smartsheet report. Is this possible? if so, how do I add the report to the outlook add-in listing on the sidebar?
-
Microsoft Power Automate Insert row
Hello, I am having an issue inserting a new in SMARTSHEET when a new form is created. I receive the following error. I was able to correct the other errors, but I at a loss on this particular error. Any help is definitely appreciated. Thanks, Shahara
