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

PhilBakerOAC

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?

SoS | Dan Palenchar

I would set up an automation to copy rows from Sheet 1 to Sheet 2 when they are added to Sheet 1. Thus, Sheet 2 will have all the rows Sheet 1 has.

Sheet 2 can use an INDEX(MATCH()) formula in the column of interest to take in the value of the same row in Sheet 1.

Though this begs the question why this strategy is being used as opposed to something like a report?

Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)

Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus

Smartsheet Tutorial Videos: schoolofsheets.com/youtube