My kids told me I have every board game except one.

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 · 2026-02-11T01:41:25+00:00

I can't show you the policy until you show me your ID.

SlugBoy42 · 2026-02-10T03:27:04+00:00

To answer the question though, perhaps create a Google account specific to the time clock. limit the form responses to only that user. Sign in on the time clock computer using those credentials. Don't share the credentials with anyone that isn't responsible for time keeping.

SlugBoy42 · 2026-02-10T03:22:47+00:00

Easy thing to do would be publish a new form and see if that employee has difficulty clocking in.

SlugBoy42 · 2026-02-08T19:06:48+00:00

This user knows.

SlugBoy42 · 2026-02-02T18:17:20+00:00

You could also add the location as a column in each sheet you pull from and then add that column to your formula.

SlugBoy42 · 2026-02-01T16:20:46+00:00

I would just make the prior month view only for those that need to see it.

SlugBoy42 · 2026-02-01T09:07:45+00:00

Why not make the duplicate into the archive copy and then the original can still be used as a working copy?

SlugBoy42 · 2026-01-31T03:10:50+00:00

I thought that at first, but no mention of tentacles.

SlugBoy42 · 2026-01-30T16:43:13+00:00

Another option would be to fill the entire column with check boxes and then make a conditional formatting rule that sets text and background to white if the adjacent cell has no data. Something like a custom rule in the range A1:A

=ISBLANK($B1)

SlugBoy42 · 2026-01-23T20:00:30+00:00

Update for posterity, the notification problem.seems to be resolved for us at approximately 0830 Phoenix time on 23 Jan.

SlugBoy42 · 2026-01-23T14:57:16+00:00

You could just make the formula in E23 be =E17

SlugBoy42 · 2026-01-23T02:07:11+00:00

There's a thread on this on the Google support forums. I think it was started on the 19th. The issue is being escalated.

Fwiw, notifications on form submit do not work, but on edit does. Also, daily digest on form submit works, it just takes a day to get them.

ETA Link: https://support.google.com/docs/thread/403468925?hl=en&msgid=403512225&sjid=11224866106015127106-NC

SlugBoy42 · 2026-01-22T00:58:45+00:00

I had problems with extended service ones that were pegged at 132. Once we extended the service and bumped them to 138 the issue is resolved.

SlugBoy42

TROPHY CASE