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...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Redo to this:

     

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

    Regards,

    MFelix

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

      • satmeh's avatar
        satmeh
        Frequent Visitor
        7 years ago

        MFelixI tried this approach before but I keep getting errors.

         

        Thanks!