Skip to content
Advertisement

Tag: google-sheets

Adding Variables to getRange()

Having a hard time with the below Google Scripts JS code. Here’s what it’s supposed to do. Copy and paste info from active sheet from column M to column AA Go to sheet 2, get the last cell with data and add one row before pasting the new information. If nothing is there then paste to the top of the

custom chart using google sheets data

I’m new to this, so please bear with me 🙂 I have a google sheet with columns: ‘Name, A-Score,T-Score, R-Score, P-Score’ Scores are numerical values from 0 to 20. This data needs to be converted to a special, but very simple graph which i don’t think is available in the existing sheets charting options. I’ve tried to write some code

Advertisement