Moving certain columns to a new sheet based on criteria

Options

Is it possible to move only certain columns to a new sheet based on certain criteria?

For instance, when an employee is terminated, I only want to move his name, termination date, and department to the offboarding tasks sheet rather than moving the entire row with so much information not needed for this sheet.

I realize that I can hide the columns that aren't needed but hoping there is a better way.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!