Beginner's Question: Is there any way I can archive sheet records to a data table via workflows?

edited 06/18/24 in Smartsheet Basics

I was able to manage setting up a basic automation of moving rows from one sheet to another based on a calculated column criteria. However, sheets only store 500,000 rows so I was thinking if a data table is the better way to go. Is this possible? I have read some things about data shuttle, sheet connections but nothing seems to fit the bill of what I'm trying to achieve. Thanks in advance!