Can I use automation to copy only certain fields from a row to another sheet?
I would like to copy only a few fields to a new sheet every time a condition is met. The current Project List has a Date Modified field. Whenever the project is updated and that field changes, I would like to have just a few select fields/cells from that row copy over to another tracking sheet. Is it possible to select just a few fields to copy?
Help Article Resources
Check out the Formula Handbook template!