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:/ /”,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.

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.


this is something that we use in google sheets.

1 Like