SharePoint Links List Open in New Window

I explored various methods to make the SharePoint link list to open in a new window at SharePoint Link list: Open in a New Window, while the methods discussed in the article are applicable for SharePoint 2013 too, there is one more: using calculated columns! Let’s drill down in detail with SharePoint 2013 to make links to open in a new window.

Here is the idea: Create a new custom list and make these changes to the list.

  1. Rename “Title” field to “Link Title”
  2. Add a field “Link URL” of a single line of text
  3. Add a field “New Window” of choice with “Yes”, “No”
    SharePoint 2013 Links List Open in New Window
  4. Add a calculated field of “Number” type with the formula:
    =CONCATENATE(“<DIV><a href='”,[Link URL],IF([New Window]=”Yes”,”‘ target=’_blank’ “,”‘”),”>”,[Link Title],”</a></DIV>”)
    open sharepoint link list item new window

Now, the list should look like:

sharepoint 2013 open link in new window

So now, When you add new entries to the SharePoint list, set the choice field to “Yes” to make SharePoint links to open in a new tab.

SharePoint 2013 open link in new tab

This method of opening SharePoint links to new window works on any version of SharePoint including SharePoint Online!

Update: In SharePoint Online links in calculated fields stays as text, instead of Hyperlink! Here is the fix! SharePoint Online: Format Calculated Column as Hyperlink

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

9 thoughts on “SharePoint Links List Open in New Window

  • September 25, 2020 at 6:23 PM

    Doesn’t work in SharePoint Online or i am not following the steps correctly

    Reply
  • June 25, 2018 at 4:10 PM

    This is working – EXCEPT, the new page is truly “Blank Page”. I suspect the following quotation marks after the ‘blank. Suggestions? =CONCATENATE(““,[Link Title],”“) (Had to modify the DIV & target command so this could be posted)

    Reply
  • April 4, 2018 at 9:07 PM

    I used same exact thing but no luck so far. What I see under the link field is a text comprised of my url and my Link title. I suspect there’s somehting wrong on the single and double quotation usage. FYI: my system is Sharepoint Online 365. Thanks

    Reply
    • June 25, 2018 at 7:43 PM

      Where you able to solution the SharePoint issue: “Open in new window, linking to a calculated column’? I do get the new window, but not with my link. It literally states, “BlankPage”. I too suspect the double quotation, but my experiments haven’t been successful. Thank you!

      Reply
  • September 21, 2017 at 7:11 AM

    THANK YOU! THIS SOLUTION IS JUST WHAT I NEEDED!

    Reply
  • August 7, 2015 at 5:38 PM

    Is there a way to have the url links open in a new browser window rather than a new tab?

    Client wants documents to open in a window so they can resize them to view side by side on their monitor rather than opening multiple tabs.

    Reply
  • June 11, 2015 at 9:49 PM

    Hi, is there any way to get the calculated column to align left, using this method? Thank you.

    Reply
    • June 14, 2015 at 7:27 AM

      “Number” type columns are right aligned by default! If you want to make it left aligned, You can use jQuery (or you can edit the Form page with SPD!) . Here is the jQuery code:

      $(document).ready(function() {
      $(‘div.ms-numHeader’).attr(‘align’, ‘left’);
      $(‘div.ms-number’).attr(‘align’, ‘left’);
      });

      Reply

Leave a Reply