Forum Discussion

satmeh's avatar
satmeh
Frequent Visitor
7 years ago
Solved

Create a new hyperlink column using value from another column

Hi All,

 

I am trying to create a column(containing hyperlink) using value from another column. Tried creating custom columns but no luck. I am importing data from a read-only database.

 

Desired output: 

ID           Link

2345       www.microsoft.com/2345/home

3346       www.microsoft.com/3346/home

 

Thanks!

 

 

Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Redo to this:

     

    Hyperlink =  "www.microsoft.com/"& FORMAT(Table[ID];"#") &"/home"

    Regards,

    MFelix

6 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi satmeh ,

     

    Did you format the column as hyperlink after creating it?

     

    Regards,

    MFelix

    • satmeh's avatar
      satmeh
      Frequent Visitor
      7 years ago

      MFelixThanks for your response. I wanted to learn how to create the desired links using 'ID' from other column.

       

      Thanks!

      • MFelix's avatar
        MFelix
        Super User
        7 years ago

        Hi satmeh ,

         

        You need to create a column similar to this:

         

        Hyperlink =  "www.microsoft.com/"& Table[ID] &"/home"

        Regards,

        Mfelix