Formula to check whether or not a cell has been hyperlinked

I am trying to create a helper column that checks whether a cell in a nearby column ("Project" in this case) has been hyperlinked or not. I want to return 1 if True or 0 if False.

Something like this: =IF(CONTAINS("http", Project@row), 1, 0)

However, when I hyperlink using the menu dropdown (see attached image), this formula doesn't work. It's a requirement that hyperlinking be done via this dropdown and NOT via the HYPERLINK function. Therefore, what kind of formula can I write that will check to see whether the cell in the nearby column has or has not been hyperlinked?

Find more posts tagged with

Formulas

hyperlink

Accepted answers

Ray Lindstrom

Hi @michelle.lewis-miller,

Unfortunately there is no formula or other functionality native in Smartsheet to determine if a cell contains a hyperlink.

It would make for a good Product Idea. Feel free to submit one here https://community.smartsheet.com/categories/smartsheet-product-feedback-&-ideas?sort=top unless you see another one already submitted for the same reason that you can up-vote instead.

BRgds,

-Ray

All comments

Ray Lindstrom

Hi @michelle.lewis-miller,

Unfortunately there is no formula or other functionality native in Smartsheet to determine if a cell contains a hyperlink.

BRgds,

-Ray

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.