-
How to only Sum values for unique requests with a specific request type
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, and I am trying to setup a columns to display the Average Days to Completion for each request type to help with estimates…
-
Sheet Historian - grab snapshots of a sheet and append them to a Data Table
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 capture the Cost To Complete (CTC) for all our projects. Each week the PMs are asked to update this sheet with their current…
-
Option to Turn Off Case Sensitivity in DataTable Lookup
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. This is making DataTable extremely unreliable. Please improve this functionality and either remove case sensitivity all…
-
Check Out My New Demo Web App: A Smartsheet Dashboard Visualizer!
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's This App About? After successful OAuth2 authentication, you'll be directed to a Smartsheet Dashboard. It's a…
-
DataTable Connection Limits increased to 1000 per DataTable
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 available to licensed users with Advance Gold or Platinum. Find out more about DataTable here and learn even more with our help…
-
Merged: Table format in forms
This discussion has been merged.
-
Dashboard and data presentation help
Hey folks! I've got multiple projects in a workspace with a pretty-ok dashboard. Each project has common milestones tracked to project life cycle and product launch. I'd like each project to be a line in a gant w/ presentation similar to that above (See image, I blocked out project names for security) Has anyone done this…
-
Add Run on Attachment for DataTable in DataShuttle
Please include a run on attachment option for DataTable in Data Shuttle. A daily up to weekly only option is very limited. We also need monthly, bi monthly, etc. Similar to the custom date automation option in Smartsheet sheets.
-
Metrics from a DataTable
DataTable is fabulous, but I have to move the data from the DataTable into sheets (usually a LOT of sheets) in order to be able to do any manipulation of the data. I'd love to be able to create Metrics from the data in a DataTable
-
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…
