All Questions
8 questions
1
vote
1
answer
214
views
How to deal with month grouping and sum of hours of these months in Google Sheets?
I'm having trouble filtering a column by month/year and counting the unique values. I started trying with ARRAYFORMULA, then with QUERY, but without success.
A
B
C
D
E
F
G
Date
Start Time
End Time
...
- 1,227
1
vote
2
answers
205
views
Google sheets converts 01/01/0001 into 01/01/2001
How to make it stops? Tried many different formattings and it gives no difference. Could not find anything in settings. Googling only gives how to stop google sheets from auto-formatting numbers into ...
- 101
1
vote
1
answer
48
views
How to Export all data in schedule after filled put another Sheet
How to export all the data in the schedule after filling it out and putting the data in another sheet, such as the name of the employee with its dates from the beginning of the month to the end of the ...
- 13
1
vote
1
answer
1k
views
How to make a custom number formatting for trillions in google sheets [duplicate]
I found this online which formats thousands, millions, and billions
[<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B"
number format sheet
how would you format it so ...
- 25
2
votes
1
answer
109
views
Why is it sometimes impossible to edit Google Sheets formula line spacing?
I added spacing to the above formula, but as you can see there is a double line spacing near the bottom, and I'd like to add spacing at the top. Yet no matter what I do, it maintains the same format. ...
- 343
0
votes
3
answers
74
views
Script to copy data and format/styling of whole columns to a new tab (same sheet)
I have a spreadsheet with a Main tab containing columns A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P
I have specific formatting for those columns that can vary from column to column and line to line: colors, ...
- 121
0
votes
1
answer
304
views
How can I edit/style only the "part of text" in all cells in Google Sheets?
This is my first question here, sorry if I sound too novice.
I'm trying to change a part of the text in all cells in a Google Sheet. I have hundreds of cells with text and also with >> symbols ...
- 1
0
votes
2
answers
5k
views
Google spreadsheet convert values from thousands to millions [duplicate]
I have a spreadsheet full of data that each number represent thousand
For example: 1,745 represent 1,745,000
How can I convert each number (in the same cell) to represent millions so 1.745 will ...
- 11