-
DataTable Run Errors
I'm trying to pull from a DataTable, but I keep getting this error message: I've tried to delete and rebuild the connection, but I'm not having any luck. Is it some type of server error, or is it another type of issue?
-
Assistance connecting document to dropdown in intake form
We would like to use the form capabilities on project sheets to prepopulate dropdown fields with preselected information from source documents or sheets that live in the same project folder. Example - if a person is updating a specific deliverable, to ensure the naming convention and correct deliverable is selcted and…
-
Multiple columns using same datatable to lookup values
Hello everyone, I have a sheet that stores part numbers / stock codes. There are 5 columns that have a part number. The "master" part number list has 45K records, and I have successfully stored this as a datatable. I have also linked this datatable to one column in my sheet, using the stock code, to look up the…
-
Merged: Validation Phone Prefix is missing for many countries
This discussion has been merged.
-
Data Table not showing data
Hi all, I'm trying to add data to a new Data Table. When I run a workflow through Data Shuttle it says 506,233 rows have been added (see image) but in my DataTable is says "There's Nothing Here" (see image 2). Any ideas?
-
Smartsheet data in Power BI Date fields - Remove Timestamp?
When I import my Smartsheet data to Power BI, the start and end date fields consistently pull with a timestamp that is nowhere in my sheet. I need these date columns to just have dates, timestamps removed entirely, so that I can tell Power BI the data type is "date" rather than "text." Is there a way to do this on the…
-
Be able to Store Comments, Attachments, Etc... in DataTable
I currently have a need to archive off records from a Smarthsheet to a DataTable that includes comments. Having the ability to include Comments, Attachments, Etc... in DataTable as well would allow use to archive several years of information into one DataTable repository would be a huge benefit.
-
Does anyone else have an issue with the date filter when using DataTable Connections?
I have an issue with DataTable and Sheet Connections where I will setup a connection and put in a date range filter between two dates 1st - 30th June, press save and the table will update with the data from 31st May and 29th June! I go back in and the connections filter has changed to the 31st May and the 29th June! In…
-
DataTable Default Access for New Advance Gold and Platinum Plans
Hi Community, Since the launch of DataTable in September 2022, we’ve heard feedback from System Admins on Advance Gold and Platinum plans that users have been asking for more access to DataTable and improvements to the current time-consuming process of manually managing the access permissions to this Advance capability.…
-
DataTable - now available in Smartsheet EU Region!
Hi Community, If you’re a licensed user on a Smartsheet Advance Gold or Platinum plan in the Smartsheet EU Region, DataTable is now available for your use! Check out our comparison article to learn more about differences between Commercial Smartsheet and Smartsheet Regions. DataTable is a way to leverage large datasets…