Lookestudio hyperlink syntex not working

[codeofelango]

Dear Team,

Hyper link syntex not working, when we add link in the hyper link, We face this error when we use

please kindly check this

[lauratilton]

Please share the formula you are using. Are you trying to construct the URL with CONCAT within HYPERLINK? If so, you may need to construct the URL in a separate calculated field, then bring it in to HYPERLINK. I’ve found that putting it all in one calculated field causes issues. 

[codeofelango]

I tried with concat in hyperlink, concat the url in another field and tried
the new field concat in the hyperlink but it did not work.

--
[image: Herfy Food Services Co. (C.J.S)]

(PII Removed by Staff)
Elango Shunmugaraj
Process Automation and Integration

Herfy Food Services Co. (C.J.S) <>
(PII Removed by Staff)
<>
<>
<>

[codeofelango]

Thank you for your reply. 

calculation i used in the field.

HYPERLINK('https://script.google.com/a/herfy.com/macros/s/AKfycbwQ8F30KxouyB4_g_CsW4igtCwXZTQL79bhbV2Bi0iHYqHbe...)

[codeofelango]

Thank you for support, Now its working.