How do I concatenate two columns and make it clickable

Hello everyone I want to know How do I concatenate two columns one of which is link and other is text but i want to make it clickable like the following expression in google sheet.

=HYPERLINK(CONCATENATE(“https:/ /api.whatsapp.com/send?phone=+91”,G4,"&text=",F4),“SEND”)

Is it possible? all ideas can help thanks.

In general, the syntax will be

HYPERLINK([Url], [Link Text])

Where [URL] is column containing URL and [Link Text] is column containing the text to display.

https://www.appsheet.com/samples/How-to-link-to-a-URL-with-custom-text?appGuidString=3f55edfc-aa53-47fc-a206-469720f10b13

1 Like

Sir I did try that and i understood the concept but for some reason i cant see the column i want to see even when its shown also i want to concatenate two columns one with hyperlink command in appsheet another a general text.

also

this is something that we use in google sheets.

1 Like