Automated Report generation on different field values

Is it possible to create an automatically generated report, say, that will run once a week, month, etc. that will pull date from all of SS (or only certain sheets) and look for 1-2 "customers" and several corresponding "customer numbers"?

For example, there are several different customer numbers associated with a customer and I'd like the report to pull all.

Thanks

Find more posts tagged with

Accepted answers

All comments

Hi @Terrapin6908 ,

This is Smatsheets. Anything is possible. Sounds complicated though. You'll likely need to create a grid to gather the information. The grid would contain the customer names or numbers you're reporting on in a column. The other columns would be formulas to search specific sheets and return a count, sum, name, etc.

Start by searching just 1 sheet to get your basic formulas working. Then add the other sheets you want searched using external range references.

Any help at all?

Mark

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.