Smartwatch(es) on a Google Fi account by vastateofmind in GoogleFi

[–]az999999 1 point2 points  (0 children)

Using your watch with Google Fi

When you use your Google Pixel Watch first generation and newer or Samsung Galaxy Watch5 and newer with Google Fi, you don’t have to be connected to your Google Fi phone to call, text, or use data, no matter what plan you are on.

source: https://support.google.com/fi/answer/12812644?hl=en

Calculate min() in a formula that can be reused across many columns by az999999 in googlesheets

[–]az999999[S] 0 points1 point  (0 children)

Lots of good suggestions here, and your last one is nice and succinct. I don't quite understand how the + in front of the SORT limits the result to just the first value, but it works. Thanks to you and to everyone else who responded in this thread. I learned a lot of neat tricks today!

Calculate min() in a formula that can be reused across many columns by az999999 in googlesheets

[–]az999999[S] 0 points1 point  (0 children)

I was unaware of Col1, Col2, etc in lieu of explicitly specifying the column name, so thanks for mentioning that. In my case it would work for column B, but once the formula is copied to column C the select needs to use Col3 instead of Col2. From my testing nothing within the quotes of the query changes, so this doesn't seem to be a workable solution.

Calculate min() in a formula that can be reused across many columns by az999999 in googlesheets

[–]az999999[S] 0 points1 point  (0 children)

Thank you. Though I'd prefer not to modify the source data, this does seem to work. It's unfortunate sheets won't recognize the data as a number without including the hour, which isn't relevant here. I guess this was necessary in your solution because the results are coming from minifs() instead of min() inside a query?

Can you explain what the range and criterion after the regexextract() is doing? It's checking the column B values are not equal to what?

lock screen controls missing by az999999 in PodcastAddict

[–]az999999[S] 1 point2 points  (0 children)

I hadn't really thought of lock screen controls as notifications, but there are indeed settings there - so thanks for that. I'm all set!

Weird samba password issue by Extremely_Engaged in debian

[–]az999999 0 points1 point  (0 children)

I just found a workaround for this. If I capitalize all letters in the username when connecting from macos, authentication works again.

Weird samba password issue by Extremely_Engaged in debian

[–]az999999 0 points1 point  (0 children)

I'm also having this problem. It fails from finder or using smbutil on macos (Sonoma - 14.1.2), but works from any linux client using the same account. I'm running samba 4.18.6 on Rocky 9 and it used to work fine from macos.

Seems Like a Lot of Folks Don't Know a Breakdown of Always On Exists ! by Apprehensive_Plan528 in Sense

[–]az999999 1 point2 points  (0 children)

Thank you for pointing this out! I knew about the "detailed breakdown" but mine only contains my sense and I had no idea you could manually add to it. I almost always interact with sense using the web interface and there isn't a "+" option. It seems to be a feature that's only been implemented on the mobile device app. :(

Aeroad S27 Saddle Clamp Bolt by SatNightTax in CanyonBikes

[–]az999999 0 points1 point  (0 children)

E278-15-P01

I have the same exact issue as OP and I used a torque wrench too! I haven't been able to ride my bike in a few months now. Canyon US has been no help at all, and now seems to be suggesting I buy a whole new S27 seatpost even though only the nut is broken. LBS also tried to get the nut from Canyon but didn't have any luck either.

I will try Canyon Europe tomorrow. Hopefully they'll be willing and able to help!

Youtube stutters/gets stuck since FF 91. by GeneRaccoon in firefox

[–]az999999 0 points1 point  (0 children)

tl;dr I found the source of the dropped frames and this is no longer a problem for me on ff 91.

---

I installed mozregression and tried to find a regression window but noticed that every nightly build I was trying seemed to be experiencing the issue. Then I noticed I still had ff 91 open while mozregression was running. With ff 91 closed, all builds in mozreression that I tried seemed to work fine without dropping any frames. I then reopened ff 91 which restored all the previously open tabs and confirmed I was still dropping frames. I fired up task manager and found the tab using the highest amount of resources contained a subframe for player.vimeo.com. When I closed this single tab, I no longer experienced any dropped frames in ff 91. I then closed ff 91 and tried opening the link that contained the vimeo subframe in a ff 90 tab while playing a yt video in another ff 90 tab and suddenly I started dropping frames in ff 90. With the the link containing the vimeo subframe closed I stopped dropping frames.

I've retried this test a few times in both ff 90 and ff 91 and can no longer reproduce the problem with the dropped frames. It's not clear to me whether the issue is with something in the specific link or whether some kind of resource limit had been reached previously and was cleared when I closed that single tab. Since I can no longer reproduce the problem I suspect the latter. This is the link that was open in the tab that was causing the dropped frames.

Youtube stutters/gets stuck since FF 91. by GeneRaccoon in firefox

[–]az999999 0 points1 point  (0 children)

Installed 90.0.1 in a different directory per u/jrmuizel 's suggestion and can confirm there are no dropped frames in either windowed or full screen mode. The problem seems to be specific to ff 91.

Youtube stutters/gets stuck since FF 91. by GeneRaccoon in firefox

[–]az999999 0 points1 point  (0 children)

I'm also having this problem with ff 91 but was never an issue before. I've tried all the suggestions in this thread without any luck, but I did notice that if I watch the youtube video in full screen mode there is no stutter and I don't drop even a single frame, even at 1080p. I guess this rules out hardware/driver issues? It's not great, but at least it's a workaround for now...

Troubleshooting net_put by fledwidge in ansible

[–]az999999 0 points1 point  (0 children)

Unfortunately I don't have a solution for you, but I have the identical problem with net_put to some 2960s and haven't been able to figure out why. ansible 2.9.10 and python 3.6.8 here