This tag is for spreadsheet questions where the question or answers involve an in-the-cell worksheet function, as opposed to some form of code.

learn more… | top users | synonyms

1
vote
1answer
29 views

Combining columns horizontally with an arrayformula

I need to join columns with a formula (not a script) in Google Sheets in a different way than others I've found--here is my original data, supposing that the Avengers train by playing racquetball: ...
1
vote
0answers
11 views

Auto populate a field with the user who made the change

This is what I use to allow Google Sheets to auto-populate the date/time in column "N" whenever any cell in that row is updated. function onEdit() { var s = SpreadsheetApp.getActiveSheet(); var ...
1
vote
0answers
15 views

match and lookup function on google sheets match different japanese kanji

Checkout this google sheets: https://docs.google.com/spreadsheets/d/1dw0v_64uN2lCyB7FxfoBmQ5d1OVIBEemxe5TtPaiUFY/edit?usp=sharing Despite the fact that those two kanji characters are completely ...
1
vote
0answers
36 views

Google Sheets: How to print information of user that is printing

Well, I am creating a sheet on Google Sheets and I will share it with some people. The users online can see its contents, but, to maintain the data update information when someone prints that, I ...
0
votes
0answers
20 views

Conditional format — copy format of another cell (Google Sheets)

I'm using Google Sheets spreadsheet, hope it's ok to ask about it here (in superuser). Chances are the methods to accomplish this might be different from Excel or LibreOffice, if it can be done at all....
0
votes
0answers
7 views

Google sheets: Automatically including new rows on separate sheet

I have a google sheet document with two separate sheets, Sheet1 and Sheet2. I want column A on both sheets to stay the same. Column A of S2 simply has ='Sheet1'!A2 for cells A2 on down. Let's call ...