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

smartsheetwilly

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

Paul Newcome

Have you looked into a row report yet?

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

Paul Newcome

Happy to help. 👍️

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. 👍️