Questions tagged [google-sheets]
Do NOT share spreadsheets/images as the only source of data. Use markdown TEXT tables instead. Use this tag for questions about programmatically interacting with Google Sheets. Use with: [google-apps-script] for questions relating to the built-in scripting language, [google-sheets-formula] for questions relating to formula design or [google-sheets-api] and a language tag (eg:[python]) for questions relating to sheets API usage. Do NOT use with [excel].
google-sheets
55,398
questions
0
votes
0
answers
9
views
Error when linking Google AppSheet with Dify
I created a to-do list using Google AppSheet.
Screenshot of Google AppSheet
Next steps...
Add a new task to Google AppSheet
↓
Calling the Dify workflow API using the linked Google Apps Script
↓
Dify ...
0
votes
2
answers
23
views
Google Sheets Vertical Lookup in Conjuction with Summation
Creating a tip-tracking spreadsheet. Using Google Sheets.
In the workbook, I have one sheet (Data) where a name may appear multiple times. I have another sheet (Summary) that is exported. The Summary ...
0
votes
0
answers
13
views
Google Sheets Web App getActiveUser not working
A web app script I'm using for Google Sheets doesn't seem to be working half the time.
It's a timestamp that should also show the user ID of the editor. But most of the time it works for like a few ...
0
votes
0
answers
7
views
API Cognito Forms and general automation
I am trying to automate the changing of a user form.
specifically, I'm not trying to automate the inputs of users, or inputs in general, but I'm trying to automate the updating of the form on the ...
0
votes
0
answers
9
views
Vertical stacking of columns from 365 pairs of rows
Link to example sheet with faux data:
So, here's a formula that works, but iterating the pattern is way too long to type by hand. I tried using chatGPT to simply iterate the pattern but it basically ...
0
votes
3
answers
32
views
Populate new columns with a header value
I try to automate as much as possible the creation of a new column and populate it with a unique "header value". I would like to automate it as much as possible and not use any additional ...
1
vote
1
answer
38
views
Querying a range and counting multiple columns and conditions
I have a spreadsheet where I am trying to create a table dynamically off a sheet with form responses, but I cant quite figure out how to get the result I am seeking and have it only partially working ...
0
votes
0
answers
28
views
Script to Recall data from a Google Sheet row to another sheet
I need some help.
googling somewhere I made a script to copy my sheet data into another sheet single row
this is my 1st sheet where I enter data:
link image1
and this is my other sheet save on row
...
0
votes
2
answers
28
views
Send contents of Google Sheet when one cell is not empty
I'm trying to write a script that sends the content of one sheet when one particular cell is not empty.
The checking part of the script is working. The email part is working too. I would like to ...
0
votes
2
answers
45
views
Copy a formula to all the sheets in Google Spreedsheets
I have a Google Spreedsheets with a lot of Sheets (more than 400)...and I need to insert formulas (H2:H13) in all the Sheets.
I know that I can do it manually..taking Sheets one by one.
I also tried ...
-1
votes
1
answer
29
views
How do you turn a command for a single active cell into a command for a range of cells?
so I'm a beginner to Apps Script. I'm currently trying to create a dropdown on Google Sheets so that users can select multiple options from the drop down. The code I currently have is below, and works ...
0
votes
1
answer
27
views
How to see certain colums and rows on an embedded google sheet on google sites
I have a google sheet with multiple tabs that I want users to be able to interact with. It is a booking system for a laptop trolley that has 30 laptops so users can book a certain amount of laptops ...
0
votes
0
answers
40
views
Is it possible in Google Sheets to get cells to fill automatically after filling one cell with a forumula?
Maybe this is a standard thing to do but I can't figure it out without getting myself into a recursive pickle.
Anyway, I have a Google form that collects data to a spreadsheet.
Let's say, a person ...
0
votes
1
answer
33
views
How can I scrape data from yahoo finance to a google sheet using importhtml?
I was trying to create a google sheet for some stock analysis.
The webpage that I am scraping is: https://finance.yahoo.com/quote/FVRR/financials/
Now I know we can use importhtml to scrape data. I ...
0
votes
1
answer
26
views
I am using Google Appscript to modifying a spreadsheet circumventing cell protections. Could anyone help suggest some reasons it is not working?
The reason I don't call the second function directly is because I need this function to be called by some users who do not have cell protection permissions. Therefore, K2 is modifiable by everyone, ...