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.
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.
User | Count |
---|---|
45 | |
29 | |
24 | |
21 | |
13 |