Create a new hyperlink column using value from another column

[satmeh]

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!

[MFelix]

Hi @satmeh ,

Did you format the column as hyperlink after creating it?

Regards,

MFelix

[satmeh]

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

Thanks!

[MFelix]

Hi @satmeh ,

You need to create a column similar to this:

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

Regards,

Mfelix

[satmeh]

@MFelixI tried this approach before but I keep getting errors.

Thanks!

[MFelix · Accepted solution]

Redo to this:

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

Regards,

MFelix

[satmeh]

This works. Thank you @MFelix!