56,402 questions
1
vote
1
answer
21
views
Can't convert cell values to uppercase using UPPER function
I am trying convert cell values to upper using a formula. I have a google sheet with this format:
ID
Name
1
usa
2
Canada
To make this, in the next cell I am putting this:
=CONCATENATE("case &...
- 1,862
-1
votes
0
answers
18
views
Google Sheets SUM until a condition fails
I have a sheet which contains monthly amounts which occasionally need to be adjusted for various reasons. Currently I'm adding rows beneath the month for adjustments and then manually referencing the ...
- 101
0
votes
0
answers
24
views
Reorder columns in a connected data table
I have a google sheets connected sheet with data coming from bigquery. Can I reorder the columns in my spreadsheet? I can't seem to drag them around.
- 6,738
1
vote
1
answer
33
views
Exception throw when attempting to read Chart.ChartOptions for existing chart
I'm trying to programatically modify an area chart within a Google spreadsheet. I want to read the existing chart's options like so; the string values in AREA_CHART_PROPS have been taken from Google's ...
- 2,321
0
votes
1
answer
42
views
How to save changes from a web app to Google Sheets using Apps Script?
In Google Sheets, I want to take certain columns from a table and create an app through deployment. I need the user to be able to edit these fields, and all changes should be reflected in the original ...
-5
votes
0
answers
48
views
How to distribute professionals in a schedule in Google Sheets [closed]
I'm working for a client and they want me to distribute their professionals, which have different availability each in a schedule (always 1 hour duration) of specific times with 3 categories of ...
0
votes
1
answer
55
views
Can I use an Array with a LONG formula that has "IFNA, TRANSPOSE, & FILTER" in it?
The overall goal of my project is to allow the user to add the "CATEGORY" (column B) and the "SUB-CATEGORY" (column C) to the "DESCRIPTION" (column A) for each row with ...
- 1
-3
votes
4
answers
116
views
How to sum up to a specific value in Google Sheets
I have a complicated situation in Google Sheets and I don't know if it there is a possible solution for this in sheets. I have a list of records with various values both positive and negative, the ...
- 1
0
votes
0
answers
50
views
Why is my G-Sheets Script not working properly? [closed]
I am in the process of updating a list that is used in my company, with an older one. The older one has critical info, that the new list doesnt have, and there are about 36000 rows and some coloums, ...
1
vote
1
answer
43
views
Not able to convert Excel file into google sheet
I have an XLS file in Google Drive. Using Google Apps Script, trying to convert to Google Sheets. But it is being stored as Google Docs instead.
function readBlob() {
var file = DriveApp.getFileById(...
- 71
0
votes
1
answer
50
views
Google Sheets App Script: Trigger on a copied sheet
I am trying to run a Google Sheets App Script whenever a checkbox is ticked.
Other users should be allowed to tick the checkbox.
When ticked, an App Script shows/hides different parts of the sheet.
...
- 43
1
vote
2
answers
48
views
Convert each name and corresponding data into separate columns
I have this data in google sheets and the name can be more or less based on the data I want to convert it into separate column.
Name
Note
Josh
anything1
Mike
anything2
Peter
anything3
Nicole
...
- 537
-5
votes
0
answers
37
views
DocketWise api query to get the matters that were updated just today [closed]
I want to get the matters that passed to the next status in appscript so i was thinking about the next link
https://app.docketwise.com/api/v1/matters?status_changed_since=2025-02-20&limit=200&...
-5
votes
2
answers
77
views
Google Sheets Count Unique Values
I need your help with a formula in google sheets.
I have a table of income data. My goal is get all unique vales of pdoctuct name and count of all its values.
E.x. "Product 1" is in two ...
- 15
1
vote
4
answers
73
views
How to calculate average sales per weekday using Google Sheets?
I have two columns, date and net sales. My goal is to get the average sales for Monday
I am trying the following formula:
=AVERAGEIF(WEEKDAY(A2:A),2,B2:B)
Explanation of attempt:
WEEKDAY(A2:A) is ...
- 111