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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!