How can I use a Calculated Value to obtain either an email address or a Website column in a SharePoint list? The column has been defined as 'Hyperlink or Picture'
If I use something like:
lookup('VendorList','Code','001-A','VendorWebsite') it returns #!Value
If I use the same lookup function in another calculated value to bring another field on the SharePoint ist, it worked fine (I.e.:
lookup('VendorList','Code','001-A','Vendor Name') it returns 'Acme'
I found out that is if I create another column with Text Format - Multiple Line of Text and put something like this on it:
Nintex will return Google with the hyperlink - I will prefer not to do this as this is an existing list that already contains hundreds of rows