Is there a way to split responses from a form into two separate columns on the sheet?

We use our SmartSheet form to submit orders for various events that we host. The form is sent to our leadership, but they usually like to see what we ordered last year, so they can compare it to what is submitted for this year.

My question is - I want to split my order form into two sections: one for this year's order, and then another section where we can enter the information from last year. Once the form is submitted, I want this year's order to go in one column, and the previous year's order to go in the column next to it.

Is there a way to accomplish this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!