How can I get my scatter plot to plot row 1 in X axis and rows 2 & 3 in Y axis
Hello when I try to create my chart it plots the time in seconds in the x axis and number of drinks in the y axis. I can’t work out how to flip this around.
Changing Script Google Sheets to script for Microsoft Excel
For data-analysis I am using Google Sheets. A company has developped a script to help us with this and to create automated reports based on these analysis. We would like to transfer our method from Google Sheets to Microsoft Excel, using the same output. Is there a way to translate the Google Sheet script to Microsoft Excel?
Export data from local excel file to Google sheets
I have some local excel files that are connected to cubes and I’m trying to search a way that I could export this data from the local excel file to my google sheets using the google sheets ID.
Google sheets – Calculating shift hours
The goal of this spreadsheet is to calculate total hours worked and out of that figure out how many hours has been in the day shift (from 6:00 to 22:00) and how many hours has been in the night shift (from 22:00 to 6:00).
Google Sheets – Multiple dropdown menus
I have some problem with the code.. I’m stuck on the third statement if “Overheights”.
I want to be able to sort by ‘Pick’,’Error’ and ‘Overheights’, but for the latter it doesn’t work exactly as planned? any ideas?
Google Sheets formula INDERECT on range
I have 3 team tabs: Team A, Team B, Team C.
I have technical tab: Teams
with prev tabs names.
Is there a way to simplify the multiselect query in the google sheets?
The source file contains 17k to 20k rows.
How to Allow Multiple Users to Save Data to a Google Sheets Form While Protecting Certain Cells?
I’m currently working on a Google Sheets-based database management solution to maintain daily records with input from different users. I have a simple Google Form that others fill out, and I use Google Apps Script to save the form data to a separate sheet in the same Google Sheets file.
Google Sheets Get Value From Another Sheet Where Value Equals
I’m using Google Sheets with two sheets: