Importing certain information from one smartsheet to another

I have created a "Grid" that is being filled in by a form from our team. I wanted to see if there is a way that IF a certain 'column' has the work "Detailed Cleaning" and it is filled with information that it will transfer over to another smartsheet "Grid" so they can focus on just that item.
For example, I have a report that has Floor cleaning projects and one that has Detailed cleaning projects. When my supervisor/manager fills in the form from doing a round it is all together on one row. I would like to separate and just take the "Detailed Cleaning" that is NOT blank and send it to a spreadsheet that is for that report and the "Floor Cleaning" that is NOT blank and send it to the other report. Is this possible? Currently when I pull the report it is showing me EVERY column that I choose whether it is blank or not due to the row under it having something in it and the one above is blank.
Answers
-
Confirming, you are asking:
a) if there is a way to move PART of a row of data from one sheet to another based on criteria or
b) are you hoping for more information on structuring a report that shows a reduced number of columns, and filtering by specific criteria?
There are options for both of these for example the Bridge Automation allows for partial row movement:
And for report filtering, I'm happy to more directly assist in best practices there.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
-
It is not just about partial rows, but only the information that is NOT blank in a report so there is not sooo much blank columns in between rows. For example, if I have a column for every location up to 7 locations and one person only fills in for 3 locations and another for 6 and another for 1. I would like to create a working report of jobs that need to be done at all these locations without scrolling across to all the columns to find out if it is filled in or not.
-
Are you able to provide some screenshots for context?
-
That is the report from the grid that we collect the data in from a form that our supervisors fill out….
-
I'm still not sure I follow. Are you basically trying to hide empty columns in the report?
-
yes, it might be easier to show you if you want to have a teams meeting that might help you understand better.
-
The only way to show/hide columns in a report is manually.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!