Welcome!

FILTER COLUMN THAT DO NOT HAVE HYPERLINKS

Hi,

I use hyperlinks in one of my columns that link to pdf files, so that we may reference to them quickly. I'd like to quickly filter through the entries that do not have hyperlinks so that we can add the missing links.

So I was thinking under filter:

Show rows that match all conditions,

[column] is not blank

[column] does not contain "https://"

But that doesn't work.

Find more posts tagged with

Comments

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

NerdyCambo

Hey Andree,

Absolutely,

So basically I just want to filter show only the "DWG #" column that do not have hyperlinks. Here's another screenshot for reference. I'll also share a dummy sheet. Thanks for your help!

https://app.smartsheet.com/b/publish?EQBCT=b2d8a35ec7b8445fa7cce025ee7a2089

Andrée Starå

Happy to help!

If I'm not misunderstanding what you want to do, I would use "Does not contain" https to get a list of all rows that are empty.

Is that what you want?

Best,

Andrée

NerdyCambo

Yes, that's exactly what I want to do!

Andrée Starå

Great!

Best,

Andrée

NerdyCambo

Hi Andree,

Thank you for trying, however I believe we may have misunderstood each other. Here are more screen shots that hopefully better explains what I am trying to accomplish.

So in other words, if the filter works as intended. Only the rows that say "Show Me" in column DWG# will appear.

Andrée Starå

Happy to (try) helping!

Did you get it working how you wanted?

I'd be interested in taking another look at it if not.

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Automation Not Working
I have a sheet set to notify myself and another user when ANY CHANGE is made to the sheet. Neither of us received the notification. Any suggestions on why this is not working? It has been a while since this form was used, but it worked previously.
Why am I not getting reminders?
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
Membership/ Access question
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…