New answers tagged google-sheets-dates
0
votes
How can I horizontally space data points on a chart when the dates are arbitrary?
Thank you to Tedinoz for the link to Discrete vs Continuous.
Once I discovered this link, I solved the issue I'd had for several hours within a matter of minutes.
The link makes it clear that
In line,...
0
votes
Accepted
Excluding specific range in Google Sheets
Use row() and isbetween(), like this:
=min(filter(C4:C, C4:C > today(), not(isbetween(row(C4:C), 58, 64))))
See row() and isbetween().
1
vote
Accepted
Automatic way to select a range for a formula based on the date
Use filter(), like this:
=map($A2:$A, B2:B, lambda(date, budget,
if(
isnumber(date) * isnumber(budget),
budget -
sum(iferror(filter(
Activities!C2:C,
Activities!$A2:$A =...
1
vote
How can I horizontally space data points on a chart when the dates are arbitrary?
I know it is a late response, but for those searching for the answer as I just did:
This is possible and automatically done if you choose Line Chart, Area Chart, and their "Stacked" ...
Top 50 recent answers are included
Related Tags
google-sheets-dates × 316google-sheets × 308
formulas × 119
google-sheets-arrayformula × 64
google-sheets-query × 51
conditional-formatting × 23
google-sheets-timestamp × 22
google-apps-script × 15
date × 15
vlookup × 13
importrange × 8
google-sheets-charts × 8
formatting × 8
google-sheets-cell-format × 8
regex × 5
text-formatting × 5
data-validation × 4
google-drive × 3
google-workspace × 3
google × 3
sorting × 3
google-sheets-custom-function × 3
google-finance × 3
google-sheets-data-validation × 3
google-forms × 2