Populate columns to new sheet based on a value of a different column in the source sheet.

I have a source sheet, that I want to use as a template, by copying to a blank sheet, but I want to filter out some of the rows. I want to populate Column 2 and 3 to a new sheet, only for rows that have "Y" in column 1. (Column 1 indicates things are ready or not, and the not-ready rows should not be used).

Data mesh does entire columns, but it looks like I need to lookup based on a unique value. The source sheet values are not unique, and there is nothing to map them to in the empty sheet, so data mesh is out.

All the examples of the other items I have seen are for single cells.

Does anyone know the solution?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!