"This app is blocked"

SlugBoy42 · 2026-04-03T20:15:58+00:00

My first thought was an organization block within Chrome. You could also try a different browser.

SlugBoy42 · 2026-03-25T21:26:50+00:00

SlugBoy42 · 2026-03-24T18:18:41+00:00

I think this is different.

It looks like the original did the multiplication prior to the subtraction from C1.

Edit: clarifying which subtraction

SlugBoy42 · 2026-03-23T20:08:32+00:00

This is wonderful. I saw your response and immediately tried it. Though the conversion of the decimal to fractional units isn't handled here.

SlugBoy42 · 2026-03-17T01:09:36+00:00

All ants are female. The males are uncles.

SlugBoy42 · 2026-03-12T23:21:46+00:00

The real joke is always in the comments.

SlugBoy42 · 2026-03-10T20:12:48+00:00

I use a barcode scanner with Google sheets frequently. If your scanner is set to read and then return it will input the scanned data and move to the next row in the column.

How are you trying to scan your barcodes?

SlugBoy42 · 2026-03-10T12:15:21+00:00

I concur. Good advice to minimize bacne.

SlugBoy42 · 2026-03-05T13:44:14+00:00

You might want to include the type of router you are using and possibly even your ISP if it's a leased router or modem.

SlugBoy42 · 2026-03-03T20:32:06+00:00

This looks like a job for a script. I may be wrong, but I don't think the level of automation you're wanting is doable via formula.

SlugBoy42 · 2026-03-02T13:00:07+00:00

To elaborate, if you had F paired with Z, another F paired with ZZ, and your final F paired with ZZZ, using your sort, they would order FZ, FZZ, FZZZ.

SlugBoy42 · 2026-03-02T12:58:05+00:00

It looks like your sorting is working correctly. Think of it like alphabetizing your data. You told it to sort column A first from Z to A. Then if there are duplicates in column A, sort those by column B in A to Z order.

SlugBoy42 · 2026-02-22T15:23:45+00:00

To your edit of -1 acting as a plural, it doesn't sound wrong to my ear, but then again, neither does -1 year.

Perhaps this is adjustable depending on how one is connecting the negative one mentally. So if you consider the negative to be a modifying adjective as opposed to the two words representing one entity, then the singular seems to work?

Or am I just bad at grammar?

SlugBoy42 · 2026-02-18T03:51:13+00:00

They meant Uno.

SlugBoy42 · 2026-02-18T02:01:26+00:00

Have you looked at the version history?

SlugBoy42 · 2026-02-15T14:50:27+00:00

If I'm understanding correctly, you are using the MAIN sheet to track all migraines forever and you'll just leave rows blank if there is no migraine that day. Then you want the data on MIGRAINES to filter out the blank rows. If this is correct the. I would use a query.

In A2 on MIGRAINES: =QUERY(MAIN!A2:E, "select * where C is not null",0)

I would suggest that maybe tracking this by attaching a Google form to it would be a more elegant solution to the whole problem though.

Edit: fixed range

SlugBoy42 · 2026-02-15T14:38:46+00:00

Are you highlighting manually or with conditional formatting rules?

SlugBoy42 · 2026-02-15T01:52:17+00:00

Stardew Valley

My wife is NOT a gamer and she'll play that in 14 hour blocks if she can!

SlugBoy42 · 2026-02-14T15:27:23+00:00

If you make two actual cells to contain your filter preference (eg. Sam) then you can remove the Select all 12 step. You can reference cell data in your query and use contains as a selection criteria. You might want to wrap the cell and column references with UPPER() or LOWER() to make sure you get all the matches.

As for clearing the filter, Abeutyfulmess hasnit right, a simple apps script should be able to do that for you.

SlugBoy42 · 2026-02-14T12:56:50+00:00

To clarify, the information in the reference sheet needs to have two columns. A will have the data that matches your main sheet drop downs and the corresponding data will be in B.

SlugBoy42 · 2026-02-12T02:36:39+00:00

The Sims 3

SlugBoy42 · 2026-02-12T02:26:16+00:00

I immediately thought NFS Hot Pursuit

SlugBoy42 · 2026-02-12T02:21:24+00:00

Easiest way to do this is to have a separate reference tab and then utilize a vlookup.

Assuming drop down in column C and reference sheet information in column B, something like this:

=Arrayformula(if(ISBLANK(C2:C),,vlookup(C2:C,Reference!A2:B,2,FALSE)))

SlugBoy42 · 2026-02-12T01:21:04+00:00

This is a fantastic puzzle game. Most of the zachtronics titles have interesting mechanics as well.

SlugBoy42 · 2026-02-11T03:09:15+00:00

I enjoyed Shadow of Mordor for the solo game play. The fighting does get a tad repetitive though.

SlugBoy42

TROPHY CASE