With App DataTable, How Do I Interact With Formulas?

I will give basic examples to see if what I would like is possible. In all cases lets assume the amount of data is >20000 rows, so I can't just add to another sheet.

How can I find the max value in a column called Count?
How do I find the max value in a column called Count where column Category is Category B?
How do I find the max value of Total where the value of Total is not in the DataTable import, but stored in another sheet that can be referenced with a unique identifier?

These are things that I can handle normally with traditional sheets. I just got access to DataTable and I was hoping that I could perform calculations and references to the table, but it seems like I can only copy the data to a sheet in a process like DataMesh.

Find more posts tagged with

Formulas

DataTable

Accepted answers

Janae G.

Hello!

Unfortunately you can't really perform calculations directly on the data stored in a DataTable as far as I am aware. A DataTable is only a holding tank for data, so you can't really do anything with it until you pull it into a sheet (via DataShuttle, etc.).

If you have too much data to pull it into one sheet, you can set up filters in your DataShuttles to send data to a few different sheets by a category or date range. Then you can find Counts, Max values etc. per each sheet, then you could create a metric sheet to pull those individual sheet metrics and combine them.

I will note that Smartsheet is working on a new sheet view, Table view, that can handle more rows than grid view- up to 50,000 rows. But it is in active development so many features are not available yet in Table view. Here's more info: https://help.smartsheet.com/articles/2483460-introduction-table-view

All comments

Janae G.

Hello!

Brenden

@Janae G., that is what I figured. I have been playing with Table view the past week. Can it already handle 50000 rows? How does it work when swapping between table and grid view that allows less rows?

Janae G.

@Brenden Yes, it can already handle 50000 rows (for Enterprise plans). However, if you have more than 20000 rows, you can't switch back to grid view on the sheet, which limits your functionality (sheet summaries, DataTable and DataMesh connections, update requests, etc. only available in grid view right now). With more than 20000 rows you are stuck in table view, and with less rows you can switch views whenever you want.

Brenden

@Janae G. , do you know when Table view will gets support for DataTable and DataMesh?

Janae G.

@Brenden I don't know- Smartsheet is working it so things will get slowly released. Hopefully soon! Here is a good resource to check what is available in Table view. You can also subscribe to an email list to get regular product updates: https://offers.smartsheet.com/product-release-notes-subscribe.html?_gl=11n8zha9_gcl_auMTc0NTcwMjYwNy4xNzQ0OTgzNDg4LjE2OTkwMjU3OTEuMTc0NjA0ODUzMS4xNzQ2MDQ4NTMw_gaMTQ0NDU3NjQ1Ni4xNzQ0OTgzNDg4_ga_ZYH7XNXMZK*czE3NDc2NzcwODckbzE0JGcxJHQxNzQ3Njc3NTQxJGoxMiRsMCRoMCRkMlZQUU5fczlCNkhKa1JJWFdxVHpEbjlXTVY4YXZWWl9uZw..

https://community.smartsheet.com/discussion/137975/table-view-initial-release-is-now-generally-available-for-all-customers

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.