Formula to duplicate all rows in one column to another column in another sheet

Hello

i am looking for a formula that would allow me to duplicate all the rows in a column onto another sheet with the intention being that if additional rows are created/modified/deleted on the original sheet that the formula will automatically update the row data on the other sheet. Cell linking is not an option due to skill level of users. Any suggestions?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!