Export meta data from Reports (count functions etc)

Hi Friends,

I am trying to create some analysis tools at work, assume the following scenario:

I have a smartsheet filled by an online form employees fill out. Each form filled and sent creates a new row in my sheet. columns like

Name Location Date of entry dropdown value a dropdown value b

How can I count entries and have a dashboard showing me

"thats how many entries we have with the tag [red]"

"thats how many entries we have from Date xxx"

etc.? Especially since the form is constantly growing.

Currently I am trying to play around with reports but I cannot set a count function in there to just count entries and return a integer value that I can use for a cake diagram or so. Any tipps?

I have not worked myself into dashboards yet, maybe thats a solution space worth checkin out?

thanks a lot!

Willy

Find more posts tagged with

Reports

Dashboards

Pivot App

Accepted answers

All comments

Paul Newcome

A lot of this is going to depend on exactly how you want to display these metrics. Sometimes a report will work with grouping and summaries, but then other times you will need a separate sheet with formulas containing cross sheet references.

Either option can be used to generate a chart on a dashboard.

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.