It would be very helpful if the automation to copy a row from one sheet to another could be done without the formatting going along for the ride. It's tedious to have to undo formatting from the source sheet in the target every time a row is added.
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
@Andrea Zenner Could you set up conditional formatting in the target sheet to set the formatting back to "neutral" when new rows are added? For example "If "x field" is not blank, then apply "this format" to the "entire row."
I'd like to request the option (perhaps a toggle?) to not copy row formatting from the original sheet to a new sheet when using the Copy Row function.
Thanks!
Holly