python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - google-sheets-formula

How to find the start date, end date and event name from a list and have it update / show based on current time?

I have a list of events (with event start, event end and event name) and I want to have a "Current Event Start", "Current Event End" and "Event Name" display based on the...
test-img

Ace

excel-formula

google-sheets-formula

Votes: 0

Answers: 0

Google Form to Google Sheets - How to constantly send form data to two different independent sheets for independent editing (Not a mirror)

I have a google form that dumps into a spreadsheet. This form is constantly getting new submissions. I need to do various different functions with this data and, in an ideal world, the form would dump...
test-img

Danielle Thieman

google-apps-script

google-sheets

google-sheets-formula

Votes: 0

Answers: 1

Latest Answer

Here is a trivially simple way to do it: function onFormSubmit(e) { Logger.log(JSON.stringify(e));//this is worth doing for your own edification const ss = SpreadsheetApp.getActive(); const sh1 ...
test-img

Cooper

How to move multiple lines in a google sheet onto just 1 based on the date?

I have many rows with data like below. I would like to end up with rows that have a single date in one column and the next column contains concatenated info of the other rows, like so: 1/20/2022 Tel...
test-img

JP Douma

split

pivot

google-sheets-formula

substitution

flatten

Votes: 0

Answers: 1

Latest Answer

try: =ARRAYFORMULA(SPLIT(SUBSTITUTE(TRIM(FLATTEN(QUERY(QUERY(A2:B; "select max(B) where B is not null group by B pivot A");;9^9))); " "; "×"; 1); "×"))
test-img

player0

Change cell color in SheetA when value changes in SheetB in Google Sheets

I have 2 sheets: SheetA and SheetB with identical values in corresponding cells. I'm trying to change the cell color in SheetA when the value of the cell in SheetB changes. For example if cell A5 has ...
test-img

gustavo

google-apps-script

google-sheets

google-sheets-formula

Votes: 0

Answers: 3

Latest Answer

It can be done this way: function onEdit(e){ var sheetB = e.source.getActiveSheet(); var sheetB_name = sheetB.getName(); if (sheetB_name != 'SheetB') return; var sheetB_cell_value = e.value; ...
test-img

Yuri Khristich

Posts

Questions

Blogs

Jobs