Questions about spreadsheet
Read more about spreadsheet
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Getting data from a single cell in different files from Google Drive
I have a code that pulls all my spreadsheet files from different folders on Google Drive and lists them in a spreadsheet.
I want this code to also write the data in cell U7 in every file that is writt...
Vivian Roberts
Votes: 0
Answers: 1
Using Dates in If Function
I need to determine eligibility as per interval dates with the condition of completing 1 year based on the current date
for instance :
Year 2021 Start Date 1-Mar 2020 competing 1 year in 1-Mar 2021 --...
user18314386
Votes: 0
Answers: 0
Combining multiple IMPORTRANGE WITH QUERY
I'm trying to import data from multiple spreedsheet to one using query,
=QUERY({IMPORTRANGE("1wMGl6qkQuz5ux42u4w8YAIEGiB3SN2b4EcgVJI-RTx4","DELIVERY DETAIL!$A$3:$I");
IMPORTRANGE(&...
IMAD LAKH
Votes: 0
Answers: 1
Copying a formula or function down a column of 1000 rows?
How can you copy a formula down a column in sheets? Not by manually dragging it. Imagine there are 1000 rows. Is there a short cut?
I have dragged the corner of the cell, but that works for a shorter ...
Waverly Gunter
Votes: 0
Answers: 2