Update a copy row
I have a form that is feeding a master sheet, with an automation to copy rows to separate sheets assigned by state.
I'm looking for a way to update the information so that it stays consistent on the master sheet and the separated sheet where the row was copied to.
The only solution I can think of is to have an update request automation on the master sheet, and another automation to copy again when it changes, but that would leave two records instead of just the updated one. Is there any way to avoid that so it is just one row per submission, even if an edit is needed?
Help Article Resources
Check out the Formula Handbook template!