AnsweredAssumed Answered

Calculated Value to obtain and Email Address or WebSite

Question asked by jagl1609 on Aug 30, 2016
Latest reply on Sep 2, 2016 by jagl1609

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:

<a href="http://www.google.com/">Google</a>

 

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

 

Thanks!

Outcomes