How can I create an auto-updated sheet that takes data from another smartsheet?

Hi comminuty,

I am new to smartsheet and just getting started. My issue:

We have a auto-updated smartsheet (filled with survey data that is pushed from a web app into the sheet). This sheet is global and I would like to create an excerpt for my local business.

Lets say the original data structure is:

name tag1 tag2 tag3

peter blue 8 false

john red 7 true

betty red 8 false

etc.

I would like to create a smartsheet that copies the complete lines with a specific entry, lets say I want my filtered list to include all lines from the original where tag3 is false. And Ideally also I would like it to update automatially.

How would i realize that? I read into index and match functions but with this I can only get cell values not a whole line - let alone the fact that I have no clue how to make it auto update in the end.

I know this is a bulk question but I am very appreciative towards whoever helps me start my smartsheet journey.

Best

Willy

Find more posts tagged with

Accepted answers

Paul Newcome

Have you looked into a row report yet?

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

Paul Newcome

Happy to help. 👍️

All comments

Paul Newcome

Have you looked into a row report yet?

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

smartsheetwilly

Hey Paul,

I just found info on that while getting the mail pop up from your answer. Smartsheet sure is cool, no doubt. This is exactly what I needed for now, thanks so much!

Paul Newcome

Happy to help. 👍️

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.