There´s a way to copy a row to another sheet with a if formula?

Sebastian Avila

Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s a date on this column.

Is this possible?

Matt Johnson

Hi @Sebastian Avila

Yes, this is possible. Below are the steps and a screen shot. If the column value changes, it gets copied to the destination sheet. If your sheet already has dates in that column you would need to re-enter those dates for the automation to take affect. (In this example, my Formal Reclamacion column is a date column.)

Step 1. Make a Destination sheet for the row to be copied to.

Step 2. Choose “Automation” on the upper left on the Source sheet

Step 3.  Set up your rules similar to the screen shot below.

I hope that helps!

Matt Johnson

Hi @Sebastian Avila

Yes, this is possible. Below are the steps and a screen shot. If the column value changes, it gets copied to the destination sheet. If your sheet already has dates in that column you would need to re-enter those dates for the automation to take affect. (In this example, my Formal Reclamacion column is a date column.)

Step 1. Make a Destination sheet for the row to be copied to.

Step 2. Choose “Automation” on the upper left on the Source sheet

Step 3.  Set up your rules similar to the screen shot below.

I hope that helps!

Sebastian Avila

Thank you very much