I am having some trouble getting this to work. I need to create a hyperlink in a column and learned that if you put some html into a calculated field and format it as a number then it works. For example:
="<a href='SiteUrl/TaskerDocuments/"&[DS/F Attachment(s)]&"'>Attachment(s)</a>"
Now I've tried to do a the following
=IF(ISBLANK([DS/F Attachment(s)]),"N/A","="<a href='SiteURL/TaskerDocuments/"&[DS/F Attachment(s)]&"'>Attachment(s)</a>"") but that doesn't work. Any ideas on how to achieve this?
I only want to display the link when a certain field that the link references contains information and say N/A when it doesn't.
I am stuck. Please help!