Chat

7499 readers

55 users here now

Relaxed section for discussion and debate that doesn't fit anywhere else. Whether it's advice, how your week is going, a link that's at the back of your mind, or something like that, it can likely go here.

Subcommunities on Beehaw:

AskBeehaw

This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago

MODERATORS

[email protected]

When you have other tools, but are too used to the hammer (beehaw.org)

submitted 1 year ago by [email protected] to c/[email protected]

4 comments fedilink hide all child comments

Lip balms here usually have a cap that you just pull to open, and that's what I had been doing with the latest one I bought. Several times in the several weeks since I first opened it, I thought it's really too hard an action. Today, maybe because I'm sick and weaker, I stopped to consider my repeated internal criticism and easily screwed the cap off.

So, I ask all of you to tell me of a moment when you realized that hammering a problem was not the best solution.

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 4 points 1 year ago

I worry that I do this in my Excel sheets.

I've figured out a set of formulas to filter sheets by specific content, identifying the rows using IFs, then using INDIRECTs to pull the values. I should probably just be using Excel's integrated filtering tool, but I haven't bothered figuring out if you can do complex filters with formulas, and with how easy it is to maintain going forward.

So I just keep hammering away, cluttering my spreadsheets with lots of "helper" columns to slowly filter down my results one layer at a time.

Or, really, I should probably be using databases for most of these things.