All Questions
20 questions
0
votes
2
answers
290
views
Combine Range As CSV
How can I combine range in a cell with comma-separated value (CSV) without writing one-by-one cell name?
I use concatenate formula, but it does not work because I can't add comma to separate every ...
- 355
0
votes
1
answer
31
views
copypaste rows based on criterea cell on googlesheet
i know i have a really stupid problem but i really can't find the problem to fix it.
i made my script that will copy and paste the data rows based on a data cell "X" that i have in my sheet ...
1
vote
1
answer
116
views
How to remove auto sort and edit below code for number entry in query group function google spreadsheet
I am trying to run a query function in google sheet for every columns separately, but it automatically sort the output in alphabetically order as shown in below image which I don't want. Also, it is ...
- 21
1
vote
1
answer
447
views
Fix formula error via formula in Google sheet after xlsx import
When importing an xlsx file into a Google sheet, I end up with a formula parse error because the cells of one column contain wrong date formulae like ==DATE(2021,3,12).
Obviously the problem is that ...
- 65
0
votes
1
answer
52
views
Google Sheets - Retrieve contents of the last modified cell in a workbook
I'm building a dynamic validation list, the missing ingredient is the following
I need to populate a cell (A1) with the contents of the last modified cell in a workbook.
I dont know the column/row/...
0
votes
1
answer
1k
views
Automatically updating csv file in sheets
I have a csv file in my PC that is updating every hour. I tried to automatize the update in google sheets too.
This was the formula I used
=IMPORTDATA("C:\Users\octav\Documentos\Movers\RD\ALGO-...
0
votes
0
answers
228
views
How can I exclude columns with blank cell while using the filter function?
I am currently using google spreadsheet to record each answer from google forms to google spreadsheets by categorizing it by name (ex. salesperson). I successfully categorized each name by using some ...
- 15
1
vote
4
answers
2k
views
Put two columns in one column in sequence one under another - Google Sheets / Excel
I want to simplify my life guys, help me. I want to, when I have two columns that I need the information of those two columns in just one - Not concatenated, the columns placed one under another - and ...
2
votes
1
answer
2k
views
Calculate Profit/Capital Gains on Sold Inventory/Shares
I have a Google Sheet (Excel formulas apply) containing 2000 transactions that are structured like below:
Link to Google Sheet with example calcs here.
I need to calculate the Profit (ie. FIFO ...
- 75
1
vote
1
answer
5k
views
FIFO Capital Gains Calculation Formula
I have a Google Sheet (Excel formulas apply) containing 2000 transactions that are structured like below:
I need to calculate the Capital Gains for every sell order and place this amount in the 5th ...
- 75
0
votes
1
answer
79
views
Creating a formula to avoid dragging down without using (=array)
I have three formulas
(1) =(B2:B&"."&substitute(substitute(lower(C2:C),"jalan","jln")," ",""))
(2) =COUNTIF('Payment Configuration'!A:A,A2:A) +...
1
vote
0
answers
388
views
Setting the range until last column in google sheet
I have a google sheet that it will update the months every year. So let say if its 2021, it will automatically create 12 new columns from January 2021 until December 2021. I am doing a script in ...
user15927343
0
votes
2
answers
517
views
Transforming several data points found in one column to multiple columns
https://i.sstatic.net/QKB6y.jpg
My input are all in one column. The information included for each data point are things like from:, to:, subject:, message: etc. I would like to separate these ...
- 247
-2
votes
1
answer
105
views
Sorting Dates in Custom Google Sheets Calendar
I am trying to populate a calendar with google sheets in the following way :
I have a sheet called processing which has all the projects and their dates (some use one date and some use up until 14 ...
2
votes
2
answers
3k
views
Split Text By every Nth Delimiter and Transpose Google Sheets
I need to extract text from a block of text. The block looks like this:
{"some text"},{"some more text"},{"some other"},{"some other text"},{"let's add ...
- 85