this post was submitted on 20 Oct 2023
20 points (100.0% liked)

Chat

7499 readers
7 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:

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

founded 2 years ago
MODERATORS
alyaza@beehaw.org
remington@beehaw.org
20
When you have other tools, but are too used to the hammer (beehaw.org)
submitted 1 year ago by elfpie@beehaw.org to c/chat@beehaw.org
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
[–] blindsight@beehaw.org 2 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.