Populate data from one sheet to another and sort

I have a one sheet that data is entered based on a form. Its day by day per what an person enters. I would like that row data to transfer to another sheet and in that sheet I want it to populate under that persons #. I've tried formulas and i only get 1 column to transfer, i need the entire row to transfer.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!