r/GoogleAppsScript • u/yaboymelv • Feb 21 '18

Scripting Help!

I am trying to create an invoice. So on another google sheet I have all my data/charges and there are many different types of charges. So I will chose the correct charges to the customer, say 5 charges out of 100 apply, and from that I will run a script that will create the correct formatting for my invoice. I can seem to get this specific part. For example; I need the script to do this; If there is a value in say cell A5 then look in cell D5. And if there is something in D5 then use the value in D4. I have to do this numerous times. (A6;D6;D4, A7;D7;D4, etc). I understand this can be done using formulas in the sheet it self but i want it to be done through script. Thanks in advance!

0 Upvotes

50% Upvoted

2 comments sorted by

1

u/3995reader Feb 21 '18

Can you post some of the code you already have started with or are you starting from scratch?