There´s a way to copy a row to another sheet with a if formula?
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?
Best Answer
-
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!
Answers
-
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!
-
Thank you very much
Help Article Resources
Categories
Check out the Formula Handbook template!
