How can I copy data from just a few columns to another sheet?

I have a large sheet where I would like to copy the data from just 7 columns to another sheet once the data in one of the columns matches the criteria needed.

For example:

Copy the data from the following columns to NewSheet once the Group column says October 2021.

Position Accepted, ID, FName, LName, Instructor, Email, Group


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!