-
Live Data Connector (Data Extract from Excel Worksheet)
Who can answer technical questions about Live Data Connector to extract data from Excel? Trying to determine if one can: Include full path to Excel workbook in Smartsheet cell Include name of Worksheet in Smartsheet cell Point to designated Excel Worksheet in designated Workbook Transfer data based on Excel Worksheet named…
-
How to change the settings of document builder so it stops cutting off my text?
I have my PDF and smartsheet mapped out to match one another and when I preview my generate PDF, the majority of text gets cut off.
-
Anybody been able to import a tab delimited file in Data Uploader via Google Drive?
I have a tab delimited file, but its normal extension is .txt which Data Uploader will not see when picking a source file. Renaming the same file with .csv doesn't work either. The same file, regardless of extension, loads just fine when opening via a sheet attachment.
-
How to get industry event to span multiple days in Calendar App w/o entering each day separately
Do you know if there is a way to get an event that I entered into a row to span multiple days in the Calendar App without entering a row for each day the event is taking place? For instance, there’s a convention that is three days long and I want it to show up in the Calendar App view on all three days. Do I need to enter…
-
Calendar App- Multiple date display
Hi there, I've been searching the learning center but can't find my answer. Our projects track events by EITHER a start/end date OR Due Date/Activation Date. Is there a way to display BOTH dates on the calendar app? The settings allow me to choose the start date and end date but I can't figure out how to get events that…
-
WorkApps - Can a User jump into the "real" sheet?
I have created a nice WorkApp with a few sheets to help my team with the 2021 budget process. Very nice. I was able to make it so they could EDIT from the WorkApp's view as well. However, there are times when they want to jump into the full Smarthsheet from there. maybe to filter or add rows or go to other sheets. Is there…
-
PowerBI sheet location/key varies from user to user
Hi all, I'm hoping someone here might be able to address the following issue i've just encountered. I've created a dashboard in PowerBI to visualize some activities in a sheet. It all works fine on my machine but when I share the PBIX file with another user, the data from SmartSheet returns a blank table. I've managed to…
-
10,000ft Bulk CSV Upload - dates not importing
Hi, I'm new to 10,000ft so I may be missing something. When trying a bulk upload with a .csv file, the start / end dates do not import into 10,000ft. I have tried several different formats, but it still remains blank in 10,000ft. When I manually enter in the dates in the use profiles and export, they show up just fine. I…
-
How do you get information from Control Center to populate on dashboards?
In a nutshell, the issue that we are having is links to project plans, once spun up in Control Center, do not appear on our Home Dashboard or on any of the dashboards of the associated Officers and Directors. Anyone have this issue or know how to resolve?
-
DataMesh - Renaming Columns
Hello, My apologies if this has already been asked and I simply could not find the answer. I am new to using DataMesh and am testing it at the moment. When you set up a Config, you obviously select the Lookup columns in both the Source and Target sheets. Now, while it shouldn't happen, if one of those columns were to be…
