-
Configuring multiple sheets to all update each other in datamesh
Hello there, I am trying to configure datamesh to work between a parent sheet and its children. I have a master sheet with like information, and an automation that copies rows to child sheets (which all contain the like information and additional information based off of departments) and am trying to link the like…
-
How I can capture actual vs planned allocation for any project in smartsheet to resource management
-
Help with editing my control center - adding a hyperlink to the provisioning process.
Hello All, I would like to add a hyperlink into the job portfolio master upon the control center provision process. We already do this with a project dashboard, but I am not sure if can be done with more than one? Each project has a "warranty notes" sheet. With each provision, the warranty notes sheet is re-named to the…
-
Copy/Move Attachments between sheets
I am currently using DataMesh to copy data from one sheet to another and wondering if anyone has ideas/options on how to get attachments copied over to the new sheet as well. I can't use the copy row feature because there are a number of rows on the original sheet that are unnecessary, and the column names are different on…
-
Data Shuttle and Googles Sheets that are connected by BigQuery
Hello all I wanted to use Data Shuttle to import data from Google sheets. This sheet has multiple tabs of which some are connected by BigQuery and some are not. When I use Data Shuttle and target the "connected" tabs the mapping only shows the name of the Tab itself and not the column names. But if I select a tab that is…
-
Calendar App Filters Legend
Hi, I am using filters on the Calendar App to create different calendar views based on the type of event on the calendar (e.g. Company-wide event, local work event, US Holiday, Int'l Holiday, etc). How can I edit the legend so that it only shows items that match up to the filter? For example, I have created a filter for…
-
US EU Migration User Lists / Contact column
Dear, i have a question, when i export a sheet to excel the contact and import it again to smartsheet the contact column just refill with the contacts i have in smartsheet others stay empty which means i would need to refill. Is there any walk-around? Best regards Nico
-
Smartsheet in PowerApps Combobox
I want a column to show up in my combobox in powerapps. I've tried to read and use the formula in MS Documentation but I cannot get things to work.
-
Can dynamic views be created from sheet summary reports?
I can see the summary reports in the source picker when creating a dynamic view, however when I select the report and click the Create button, the process hangs. I've had the same results a summary report with multiple source sheets and a summary report with one source sheet. In both cases, the Create button turned from…
-
Is there a way to automate sheets using Dropbox?
I was wondering if there is a way to transfer information from Dropbox into Smartsheet. I've read some articles about Data Shuffle and Bridge, but I am unsure if those systems can do what I need. What I am looking to do, is when a certain file or folder is updated in Dropbox, or new information enters a file, I would like…