CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Rasa Laimikyte
Rasa Laimikyte

Reputation: 1

Change URL based on cell value

I am complete beginner so apologise in advance if question is too basic. How do I make url to change automatically basaed on what is in cell B3? I'm using json within Google Apps Script.

For example, if my url is https://stackoverflow.com/questions/ask , how would I replace 'ask' with whatever is in cell B3?

Thanks!

Upvotes: 0

Views: 634

Answers (1)

oshliaer
oshliaer

Reputation: 4979

The best way for this is to use a formula

=HYPERLINK("https://stackoverflow.com/questions/" & B3, B3)

enter image description here

Upvotes: 1

Related Questions