@black, would you mind using this formula as shown in the image shared below:
=CONCATENATE(HYPERLINK("https://kc.humanitarianresponse.info/attachment/original?media_file=username/attachments/"),C2)
From the formula shared above, please be sure you use the correct server URL:
https://kc.humanitarianresponse.info if you are using the OCHA server and https://kc.kobotoolbox.org if you are using the HHI server.
Similarly, please be sure to change your username and also the cell position.
Kindly please be informed that we will update our support article soon.
