- 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…
- How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
- 数据表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…
- Error encountered with DataTables: Error getting CSV primary key values
I'm using Data Shuttle to upload data onto a new Data table. For this upload workflow, i am using an existing smartsheet attachment (from offload workflow) However, running my upload workflow caused an error: If i were to replace the target from Data Table to a sheet, it can run without any error. Here's the fields in my…
- 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…
- 内容为比较快any'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…
- Table in Forms
It would be extremely helpful to be able to add a data table to a form. I need to be able to ask users to provide details about, for example, grazing in multiple paddocks. My table would look like this: Column 1 Header: Paddock No. Column 2 Header: Crop Type Column 3 Header: Area Please add this to the list of development…