Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to automate putting rows (based on conditions) of one sheet to a second sheet?
My sheet 1 has a structure with column 1, 2, and 3.
My sheet 2 has a structure with the same columns as sheet 1 - column 1, 2, and 3 - plus new columns column 4 and 5.
Based on values in column 2 in sheet 1, I would like to export the row in sheet 1 that satisfies a condition, to sheet 2. Once sheet 2 is updated, I will put in new values in columns 4 and 5.
Sheet 1 has many rows, and cell linking becomes tedious if I have to set cell linking for these rows to export to Sheet 2. I also cannot use the Report builder, since I need to be able to put in values in new columns in Sheet 2.
How do I automate this requirement?
Thanks in advance,