-
Sheet Connection to a DataTable vs DataMesh?
Hello everyone - I have a DataTable with 40K+ rows and would like to sync a subset of those rows to another Sheet. Is it best to connect the target sheet to the DataTable with a filter via a Connection, or would it be better to create an interim sheet that has a subset of rows from the DataTable and then use DataMesh to…
-
DataTable doesn't update sheet row after unique identifier changes
Hello, I have a sheet with a connection to a DataTable. The unique identifier is email addresses, sometimes I have to update the email in the sheet as it's changed. After I change it, the row's cells are not updated with data from the DataTable. I've confirmed that the DT does have the updated email and it's data points…
-
Best Way to Pull A Ton of Data
Hello Community, I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.…
-
In-App and Email DataTable Sharing Notifications
Hi Community, In December 2022, we released Sharing & Permissions within DataTable that allowed you to share others to your DataTables with Admin or Viewer permission levels. However, with this initial release, there were no notifications given to the shared user. With this release, we have added in-app and email sharing…
-
How to load excel dates into DataTable via DataShuttle
Hello, I am trying to load dates from an excel file into DataTable using DataShuttle. The excel file is an attachment on a Smartsheet sheet. DataShuttle is configured to load the date field as a date. I am able to load the date values into DataTable but DataTable does not recognize these values as dates. I also tried the…
-
Smartsheet named to Fast Company's Annual List of Most Innovative Companies 2023 ⚡️
Have you heard the news? Smartsheet was just named to Fast Company's annual list of the Most Innovative Companies 2023 in the Enterprise category! We were recognized for creating a unified digital workplace, allowing users to drive meaningful change. They specifically called out DataTable, Brandfolder, and Outfit. 🎉 Read…
-
Datatable Re-Organize Columns
It would be convenient to be able to re-organize columns in Datatable. For example if I didn't add column B at the initial setup but did add columsn A, C, D, and I want this data later, I can't insert it where I expect to have this data. This is more of an issue with several columns but the only workaround I've found is to…
-
Unable to disable DataTable connections to sheets. Has anyone encountered this?
I have not had any issues in the past with disabling the connections. I have 30 sheets with connections, when I disable the connections they show disabled but after a few minutes they become active on there own. The sheets have many connections to them via formulas (index/match) and smartsheet apps (dynamic view, data…
-
Data Shuttle and Smartsheet Attachment workflow is not working
When source location is a Smartsheet attachment, I get the following error "Please select source in order to see dropdown menu". The original workflow was having intermittent issues and then broke completely. Tried to build a new workflow and that is is when the error message appeared. The band-aid solution is time…
-
Data cannot be charted, unable to read source data.
I am using a template from Smartsheet (Project Tracking and Rollup). When I attempt to link the sheet to my chart widget, I get the "unable to display chart" notice. The chart should show percentage complete, but it doesn't. I will add photos of what it should look like, the notice, and the sheet that the chart is pulling…
