Help Extracting data sets that meet criteria to new sheet.
Hello, I am new to smart sheets. I have spent the last week trying to find a solution with no luck. I am sorry if I am asking a question that has been, probably, answered a slew of times.
I have a form built that collects data on visits to one of four locations.
"Activity Tracker" is the name of the sheet where the information is sourced from.
Hopkinton Activity Tracker is where we would like to extract Hopkinton specific numbers to.
In this form there are 4 possible locations that could be visited.
I want to be able to then split this data into 4 separate sheets based on location.
I would like for the information noted above to get pulled into the correct location sheet based on a single location criteria.
If location = Hopkinton, pull all the above data into the Hopkinton sheet
If location - Tokyo, pull all the Tokyo data into the Tokyo sheet.
Once in their respective sheets we would then use the metrics to figure out averages and trends.
Best Answer
-
@Coen You can probably do this easiest with Workflow Automation.
Create a new Workflow Automation task.
Trigger: When rows are added,
when Location is Hopkinton
Run workflow: When triggered
Action: Copy rows to Hopkinton Activity Tracker sheet
Repeat for the other three locations.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
@Coen You can probably do this easiest with Workflow Automation.
Create a new Workflow Automation task.
Trigger: When rows are added,
when Location is Hopkinton
Run workflow: When triggered
Action: Copy rows to Hopkinton Activity Tracker sheet
Repeat for the other three locations.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Some notes on Copying rows to another sheet:
The first copy will create any missing columns in the destination sheet. So you don't have to bother setting up anything in the new sheet, copying a row will create the columns.
You can have additional columns in the destination sheet that don't exist in the source, there will be no effect on the copy process. This is handy for having other columns performing data transformations on data from the copied columns, recording metrics, etc.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Amazing! Thank you so much for this help! This is far easier than the paths I was going down!
Many, many Thanks!!
-
This is super helpful. But I cant seem to search for any sheets in Select a destination search window- whatever I type returns no results?!
-
You may have to sign out of Smartsheet and sign back in, or delete your browser cache.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!