If checkbox is checked, add certain fields to a destination sheet
I am hoping for a formula/solution for a cross sheet formula. If a checked box is checked on the source file, I want to add info in 8 columns to a destination sheet. I have two software request forms (and I need to have 2 forms) however 8 columns have duplicate information. Instead of having users file out the same information on both forms (mostly contact info) I'd prefer if a checkbox is checked then all contact information is copied to the other sheet.
Help Article Resources
Check out the Formula Handbook template!