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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!