-
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…
-
Data Mesh Within data tables
I have information in data table A that I need synced over to data table B. The reports come from separate sources so they cannot be synced outside of Smartsheet. Another way of solving this would be allowing multiple connections per sheet. Both an add and update as well as a Look up.
-
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…
-
If you have Bridge, what are you using it for?
We just got Bridge, as I try and learn it, I am trying to think of all the use cases. Also, has anyone done anything with Bridge and Data Tables together?
-
How to push data into Data Table via API?
Hello, Is there an API to push data into Data Table in Smartsheet? We have a client using Smartsheet and we are able to push data into sheets using the SDK. However we have been asked to feed them into Data Table directly. I can't see anything in the API documentation related to Data Tables. Is it even possible? I read…
-
Connecting two DataTables to one sheet
Hi there, I was trying to set-up DataTables as a replacer for my current set-up of DataShuttling data from OneDrive to a Smartsheet sheet, then DataMeshing it to my target sheets. Now I connected one DataTable to my target sheet which worked fine. I tried to connect another DataTable to the same target sheet but I cannot…
-
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…