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

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!

    • MFelix's avatar
      MFelix
      Super User
      7 years ago

      Redo to this:

       

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

      Regards,

      MFelix

      • satmeh's avatar
        satmeh
        Frequent Visitor
        7 years ago

        This works. Thank you MFelix!