All Questions
1,190
questions
0
votes
0
answers
17
views
Is there a formula capable of building rows in google sheets? [migrated]
Not sure if this is possible or not, but essentially I need a formula that is capable of building rows in google-sheets.
My data is currently like this: Column A = Property Name, Column B = Routines. ...
0
votes
0
answers
3
views
How to Prevent Duplicate Entries in Google Forms and Notify Users Using Google Apps Script [migrated]
I'm working on a project where I need to prevent duplicate entries in a Google Form based on a barcode number field. When a duplicate barcode number is detected upon form submission, the submission ...
0
votes
0
answers
4
views
Google sheet ROI formula not working [migrated]
My google sheet formula isn't working as intended.
In order to calculate the ROI of an event im making I use different stats and make a big calculation of points at the ROI collumn [![Presentation of ...
0
votes
0
answers
5
views
How to return values horizontally in Google Sheets [migrated]
Say I have a column like this:
User1 Item1
User1 Item2
User1 Item3
User1 Item4
User1 Item5
User2 Item1
User3 Item1
How can I return them like this in a filter/lookup formula:
User1 ...
0
votes
1
answer
42
views
How can I keep multiple rows of data while only displaying one row, but the others show up when moused over or selected?
Basically, we have a rickhouse full of barrels. Each rick/slot is 3 levels/rows high. We have 180 ricks/slots, or 540 levels/rows. Each row is 10 barrels deep. So each barrel has a rick number, a ...
0
votes
0
answers
27
views
connecting windows share to chrome os
On my home network, I have a repurposed 2012 R2 Server, multiple Windows laptops and some Chromebooks. All on the same network. TP-Link wireless router. Archer A9 v6.0.
Server is plugged in directly ...
0
votes
1
answer
33
views
Leave cell blank until data is entered when multiplying
I have very little experience with spreadsheets and computers in general compared to, I assume, all of you. So, if you could spell out the answer to the below question as clearly as possible, it ...
0
votes
0
answers
30
views
How can i run chromium browser from terminal in Openfyde OR Chormium OS
I am using OpenFyde / Chromium OS and I need to run the Chromium browser from the terminal. Specifically, I want to open Chromium with certain parameters like setting the zoom factor and starting in ...
4
votes
1
answer
166
views
Consolidate Data from Multiple Columns into One Column
I have a dataset that looks something like this:
Customer
Col1
Col2
Col3
Bob
111
2221
Michael
112
Anna
113
2223
Rachel
114
2224
334
Person5
115
I'd like to put all data into one column, ...
0
votes
1
answer
42
views
ChromeOS - after update, segmentation fault for all shell commands
My current version:
That's what I'm getting when I type shell in ChromeOS terminal (Ctrl + Alt +T):
I also noticed I'm not able to use any command, for example:
What can I do to fix that? Without ...
0
votes
2
answers
30
views
formula to count in how many cells first digit is greater than second in last pair
Let's say I have row of cells A1:A10 with values like "46 64 76", "63 60" etc. Two or three pairs of digits separated by spaces. I need to count in how many cells in last pair ...
1
vote
1
answer
51
views
SUM of a range of durations in an XLSX-Formatted sheet always returns 0 or errors
Excel document
I have the following XLSX-formatted spreadsheet in Google Sheets
I'm trying to set a formula on cell R5 (colored in red) so that it adds up all the times in the range L4:N42 but ...
0
votes
0
answers
56
views
Can I use Google SGE (Search Generative Experience) on MS Edge?
I have a question on Google SGE (Search Generative Experience).
In the official document, it says that Google SGE is supported on Chrome. When I tried it on Microsoft Edge, it worked for one of my ...
0
votes
0
answers
41
views
How to search the web via context menu with quotation marks using only mouse?
I often drag an English phrase and search it in Google or Bing with quotation marks to find the exact expression.
Dragging with the mouse, right-clicking shows me a context menu of "Search 'the ...
0
votes
2
answers
112
views
Get first and last values for a range
Say I have a range, A1:A27, and that range has a mix of empty and non empty values, I would like two functions: one to get the first non-empty value in the range, and one to get the Last non-empty ...