How do I move certain values from one sheet to a different sheet?

My attempt:

Step 1: Sheet #1 get populated with new values (via a form submission(s))

Step 2: When Sheet #1 has a new value/row, only certain columns get populated into Sheet #2(i.e. ID number, case name, details)

I tried the automation feature, but the whole row gets copied. I want it so that only certain information/columns get populated in the new sheet.

Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!