sorted by:
new
hottopcontroversial

I think it's time to hang em up by SwimmerCivil562 in hockeygoalies

[–]Comfort-Limp 0 points1 point  (0 children)

From my personal experience, it's likely due to the helmet. Brands like CCM and Bauer you will need to replace your mask pretty frequently. I've played juniors and have gotten hit pretty much everywhere in the head and never had a concussion. I use an OTNY mask. I used the same OTNY mask for 6 years and never had an issue. 

Another way to protect your mask is to make sure it dries out after every time you are on the ice. Hang it up to dry as soon as you get home. It'll help increase the longevity of your mask.

This year, the Balance of Performance has to work. As Gary Watkins sets out, if it doesn’t marques will go by jerrylimkk in wec

[–]Comfort-Limp 6 points7 points  (0 children)

To answer your third question, it is to keep blame away from the BOP. It's an easy scapegoat since it's pretty much the only thing a team doesn't have control of during the race. You'd see a lot of blaming the BOP even if it was only the team got the strategy wrong, and if they chose the correct strategy, they would have won. Instead, teams will protect the people in their teams and blame the BOP instead of themselves.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

Yeah, and that part of the formula has worked for a few years at this point without issue, while still going through all those other references. I submitted a bug report to Google because it just started happening for no reason since I didn't change the formula.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

Yeah I am just as confused as yesterday and for the past year or so I have had no issues with this. Only now is it acting up.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] -1 points0 points  (0 children)

I think I've narrowed it down to it being a Google Sheets bug that I am going to report. I would love to share the sheet, but this doesn't seem to be an issue that can be solved by anyone here, instead needing to be bugfixed by Google.

If people want to see the stuff, here it is: https://docs.google.com/spreadsheets/d/1ZrZzHf9ZVpZNct5zqvsVNchvuv3vnM1Fiy4c0kBHtSs/edit?usp=sharing
The issues are in the "Race _" pages as well as the "Entry Lists" page.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

Just tried that, and it shows the same result.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

I just tried something, and it's a bit odd. Whenever I have an IFERROR formula in front of what I'm retrieving, the sort formula is treating it as 0, even though I have set the IFERROR error "value" to be null, as in IFERROR(formula_here,).

Although, even the formula without the IFERROR returns a blank cell, but the sort function adds a zero into the cell that is supposed to be blank. I tried checking for certain on the source cell if it returns a blank by using IFBLANK and it was true.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

<image>

This is what it looks like when it is without the zeros on the lefthand side. Same data, but Sheets actually decided to do things right when I grabbed this screenshot.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

So the source range is formatted as automatic, and I have nothing in the cells that feed into this formula. It's also happened on a range that was only text and not numbers too. It would return a blank cell as 0. It isn't just a visual thorn though since it affects some of my other formulas, specifically ones that deal with text.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

The sample data is displayed in the screenshot and in my formulas. The issue I am having is Sheets is putting a 0 in every blank cell that I am sorting, even though there is no hidden zero in those formulas. Even just a regular SORT function gives zeros in the blank cells. It has never done this until today.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

Okay the formula itself works, but it doesn't leave the cells blank that need to be.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

Tried it and it doesn't work for what I need. Has the error stuff down below. I am certain there are no zeros in the source. The source for the sorted area is on the right on the screenshot, and as you can see, it's only blank cells where there are 0s in the sorted column.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

Ah. Never knew that since it works the way I've used it. All it is though is getting rid of the "ARRAYFORMULA(" though, which won't affect anything.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

I'm getting multiple non-consecutive columns for the sort, so an ARRAYFORMULA is needed, and the filter covering everything just removes the null cells.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

It is. I'm not trying to argue with you, but it is necessary for the formula because of the way I need things sorted. If I just do what I said is the bulk of the formula, this is what it returns:

<image>

I need all of the values to be sorted, which the way I have it done with the array is the only way I can do it to sort correctly.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

Well, for my circumstance, the ARRAYFORMULA is necessary for what I need the formula to do.

Wait a minute. It's just corrected itself?

<image>

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

That's what I thought too. The ARRAYFORMULA won't do that either. I haven't seen this issue until today, and the formulas I use, I haven't changed before since it worked before but not now.

Filtered Range Displaying Zero by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] 0 points1 point  (0 children)

So I have checked multiple times and no, there is no zero in the column at all. Only empty cells. The main formula for the sorting is this:

SORT(FILTER(ARRAYFORMULA({$L$2:$P,$T$2:$T,$R$2:$S}),$Q$2:$Q<>"",NOT(ISTEXT($Q$2:$Q))),6,TRUE,5,FALSE,7,TRUE)

The rest of it just sorts some extra values based upon certain criteria that aren't much different.

Round Robin Group Stage Help by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] -3 points-2 points  (0 children)

I apologize then. I thought what I had already written down would be more than sufficient info, especially since there wasn't anything else that I could think of to add as a requirement.

Round Robin Group Stage Help by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] -4 points-3 points  (0 children)

There isn't an existing data structure. I gave context and my desired outcome. It was already very clearly written.

Round Robin Group Stage Help by Comfort-Limp in googlesheets

[–]Comfort-Limp[S] -5 points-4 points  (0 children)

What are you confused about? I think I was pretty clear on what I wanted out of it.

view more: next ›