-
Transpose with a merge
I have the following data set: A 1 A 2 A 3 B 10 B 20 B 30 B 40 C 10 I want to get it to be A 1 2 3 B 10 20 30 C 10 How to accomplish this in smartsheets when the number of items for each group are different?
-
Can I unlock the "Assigned To:" field in the Outlook Add-In?
Currently my organization is using Smartsheet to submit technical support tickets. When we submit these tickets, we would like to be able to assign them within Outlook, but the field is currently locked. Is there a way to unlock this field within the Outlook Add-In?
-
Dynamic selection of drop-down options in a form
Hello, I am interested in finding a solution to dynamically choose what options a drop-down list displays when a certain value is selected in another drop-down. As an example: We have Category 1 and Category 2 with the following options: and a form with 2 drop-downs - one for category and one for option. When the user…
-
Bridge: Way to delete all rows in a sheet
I've found a few ways to delete all rows in a sheet using scripts and multiple workflows, but I was wondering if there's an easier way to merge this into one flow. I just have the flow check if a row exists in get sheet, if there is a row then delete row 0, until the array = 0 then it stops. It works, but it's just super…
-
Not Bringing in ALL items from Sharepoint List
I am using bridge to connect to an existing list in SharePoint. This is part of a bi-directional connection I am making between my Smartsheet and SharePoint. I have been successful in pushing updates made in Smartsheet to Sharepoint. However, when creating the workflow to push updates (for separate fields from the push to…
-
Share Data Shuttle Workflows?
When someone creates a workflow in Data Shuttle to import data from a CSV file, how can we share this with other team members to support and adapt if required? Also if they are on leave, to enable other to run the workflow.
-
Update Column Formula with Control Center
Hi, I'm trying to update a column formula with control center. When I do Find/Replace and look at the test sheet, it's not updating. Original Formula :=IF(Summary@row = true, "", [Amount I]@row + [Amount II]@row + [Amount III]@row - [Allowance I]@row - [Allowance II]@row) New Formula: =IF(Summary@row = true, "", [Amount…
-
Smartsheet + DocuSign Integration
This discussion was created from comments split from: Smartsheet + DocuSign Integration.
-
Smartsheet + DocuSign Integration
Does anyone have any helpful troubleshooting tips for addressing when documents are completed and signed in DocuSigned, but NOT returned to Smartsheet for some reason? I've logged in/out, refreshed, etc. I've run tests which were successful. Seems like an intermittent problem. strange; very strange. Any ideas?
-
Summarize Multiple Sheets onto Another Sheet with Two Criteria
I have six sheets, "Log X," with an identical setup and identical column headers. I want to be able to summarize one column, “Amount,” based on criteria from another column, “Budget ID,” on each of the six sheets onto another sheet, "Budget Sheet”. Here are sample info from two of the six sheets, titled “Log 1” and “Log 2”…
