+ Start a Discussion
Hey SandboxHey Sandbox 

How to use HYPERLINK in Formula (Number) type field?

How to use HYPERLINK in Formula (Number) type field?

Like, There is a exisitng field UserId__c (Number[18,0]).
I want to set custom HYPERLINK value and along with UserId__c value.
HYPERLINK("?id=" & TEXT(UserId__c), UserId__c)
On creation of Formula(Number) field. It will give Error: Incorrect argument type for function 'HYPERLINK()'.

Please help!

Thanks,
Prashant Raiyani
Best Answer chosen by Hey Sandbox
Shruti SShruti S
The HYPERLINK method expects both the parameters as text, but in your case the second argument is a number. Hence the corrected formula will be like - 
HYPERLINK("?id=" & TEXT(UserId__c), TEXT(UserId__c))
Please feel free to ask if you have any more doubts.

All Answers

Shruti SShruti S
The HYPERLINK method expects both the parameters as text, but in your case the second argument is a number. Hence the corrected formula will be like - 
HYPERLINK("?id=" & TEXT(UserId__c), TEXT(UserId__c))
Please feel free to ask if you have any more doubts.
This was selected as the best answer
Hey SandboxHey Sandbox
Hi Shruti,

Yes, you are right. It's work only for Formula(Text) field. Hyperlink not works for Number fomula.
I've also used above for my solution.

Appreciated for your help, please mark above as a Best Answer!

Thnaks,
Prashant Raiyani