-
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…
-
Data Shuttle expressions
Hello How can I get the total count for all entries on a weekly basis using Data Shuttle? Currently I get the total count imported to a sheet. This count is currently 26 entries and it fluctuates weekly. I would like a way that data shuttle using expressions can provide me this total count in one cell. Thanks for your help.
-
How can I upload Excel without losing groups and hierarchies?
My excel has rows that are indented to show groups and hierarchies. Can Data Shuttle do the upload so that I don't have to manually recreate ancestor levels?
-
Flow charting process
I work for a non-profit and I have been tasked to flow chart all the process and procedures and to create swim lanes. How can that be easy done in smartsheet? Thank you, Nigel Lomax
-
Smartsheet Pivot App & Calendar Apps
Hello, I am looking to build a pivot table, but I see an App is required in order for me to do so. Does anyone know whether you need to continue subscribing to the monthly app after you've built the pivot table in order to keep viewing it? Additionally, how helpful is the Calendar App versus building your own annual…