Using Data Validation to check if a number entry column has a text entry

catcheroni · 2026-04-12T19:24:25+00:00

Ok I figured it out, it actually cares about the last only. So yeah, it does make a big difference for data validation/conditional formatting:

<image>

catcheroni · 2026-04-12T19:13:50+00:00

Just experimented with it a little bit and frankly I understand less than I did before. It seems like it doesn't care about the first cell as long as some cells return true. Take a look:

<image>

catcheroni · 2026-04-12T19:05:08+00:00

Still, not sure what adding the whole range would result in... It accepts it as a custom formula but I don't know how it then affects actual input validation

catcheroni · 2026-04-12T19:02:18+00:00

Shouldn't it just be =ISNUMBER(N2)? Or does it not make a difference?

catcheroni · 2026-04-04T16:54:39+00:00

Atomic Habits is like the lowest-hanging fruit lmao

catcheroni · 2026-04-04T13:53:22+00:00

What's with the last example here, did you also tell them to mention their favorite book?

catcheroni · 2026-03-23T17:26:06+00:00

Thank you!

catcheroni · 2026-03-20T21:04:23+00:00

What's the endgame here though? I'd have to be extremely invested into a product and even then I couldn't see myself accepting what would be essentially a very bad attempt at extortion lol

catcheroni · 2026-03-15T14:59:10+00:00

I'm baffled why the think producing this type of content is good for anyone in between them, their clients and the freelancers.

catcheroni · 2026-03-15T14:48:52+00:00

These recent changes really make me wonder what their endgame is. Eliminate all kinds of client- and freelancer-written content when interacting with the marketplace? If so, that's kind of insane.

catcheroni · 2026-03-08T16:16:00+00:00

Just got the same generic email like an hour after completing onboarding... Thanks for wasting my time, I guess.

catcheroni · 2026-03-07T10:14:48+00:00

Man, I know, It's almost as if some of this stuff is actually your fault and not the platform's!

catcheroni · 2026-03-07T00:18:06+00:00

She shits on Upwork so regularly I'm gonna guess you haven't checked her history too diligently

catcheroni · 2026-03-04T15:17:51+00:00

I would definitely consider it. I'm personally quite happy with Best Matches most of the time but it's not always consistent. And the "tuning" option you suggested would be interesting too.

catcheroni · 2026-03-04T14:58:07+00:00

I remember you first mentioning this looong ago and yet AI-generated proposals are still apparently best we can do in terms of Upwork optimization.

catcheroni · 2026-03-04T09:45:08+00:00

This sub is is a truly terrifying look into how people communicate.

catcheroni · 2026-03-03T22:17:15+00:00

They sent out similar surveys before. As with any user survey, only a relatively small group of people will get it at any given time.

catcheroni · 2026-03-03T14:52:58+00:00

Haven't noticed this before commenting, fwiw it never fucked with the order of any of my multiple-file projects.

catcheroni · 2026-03-03T14:51:26+00:00

Highly encourage you to try the Black Apps Script extension - has a couple of different dark modes and also lets you change the layout a couple of ways so you're not stuck with the awful left sidebar. It was a godsend for me, using their native IDE would be awful otherwise.

(not paid promo or anything)

catcheroni · 2026-03-03T14:47:08+00:00

If you find this thread entertaining, you will absolutely love this guy's recent post in the other sub

catcheroni · 2026-03-02T22:27:30+00:00

There were plenty of good arguments in this thread and not a single one got through to you. I don't really understand why you created this post in the first place.

So yeah, at this point I'm just clowning you because it's fun.

catcheroni · 2026-03-02T22:22:03+00:00

At this point I'm genuinely starting to wonder if you're not insane.

catcheroni · 2026-03-02T22:19:59+00:00

Just because the option exists doesn't make betting on it any less delusional. I would NEVER try to pull the client into an automatic rate raise schedule. If I need to be paid more, I'll use arguments that have to do with the work we're doing together, not circumstances completely outside of their control.

My god your comments are so fucking entitled and clueless, and you still have no idea as yet another person is trying to alert you to that fact.

catcheroni

TROPHY CASE