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
Might it be that I need a patch or I'm in a different version than you? I can't get it to work. Everything is correct, the names are correct and the filter as well... it is working for all fields but the hyperlinks ones (web site and email address)