conditionally copy to another sheet

I'd like to configure my sheet to read a single column and copy only certain columns to another sheet.

Example: in the second column I have these options from a dropdown menu: apple, banana, carrot

If "apple" is selected I only want columns 1-4 and then columns 8 and 9 (of 10 total columns on the original sheet) to copy over to the new sheet for just "apples" from the original sheet.

Any help is appreciated and let me know if I'm not explaining this well enough.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!