I have a lot of project data stored in a data table. As I have Control Center generate new projects, I would like to be able to pull reports or information from Data Table to populate sheets in the pr…
I have a DataTable containing time entries from 2023. I would like to bring them into each project and I can do that by manually connecting a sheet in each project to the DataTable and then filtering …
Hello, I am working on a project where I am pulling in employee utilization totals from sheets being populated by data shuttle on a bi-weekly basis to a table that calculates totals. The cloumns are b…
How do you go about archiving large data sets from sheets? I know you can create automations to move rows to another sheet but what happens when that sheet gets too large as well? I have thousands of …
How do you go about archiving large data sets from sheets? I know you can create automations to move rows to another sheet but what happens when that sheet gets too large as well? I have thousands of …
Hello, I have created a sheet to calculate some data points based off of an archive of requests that get pulled from an Automation when Estimated Completion Date and Actual Completion Date are changed…
I'd like to be able to grab copies of a sheet and append them to rows in a datatable so I can build a "historian" over time. This is the use case: I have a sheet that all our project managers use to c…
For example, if I am using an email address as the unique identifier, the cases have to match for it to sync correctly. No one ever gets the case right on an email address which is inherently, unique.…
Hello All, I'm excited to share a simple yet effective demo of my new web app showcasing Smartsheet's API's power. You can find it here: https://api.smartsheetdev.io/login. It's Free and secure! What'…
Hi Community, We’re increasing the DataTable Connection Limits from 100 per DataTable to 1000 per DataTable so you can leverage your data from DataTables in even more sheets! DataTable is only availab…