Hi!
I will be happy to help you with that. We can create Google Scripts that duplicate ranges or sheets and that can add any formula including conditional statements.
I am specialized in developing Google Apps Script. All of my reviews are related to that field. I do have experience with writing scripts for all of Google Apps, but most of my work is in G Sheets.
You haven't mentioned much details in the description, but I will be more than happy to hear more details from you, address any of your questions and make any required suggestions!
Sincerely,
Mohamed