Google Sheets auto link formula?

[Invincible Sugar]

Hello! I am making a contacts list for my Discord contacts because Discord itself doesn't have a contacts list feature.

 

One of the details I am saving is the person's Twitter username. I am making each name a clickable link but the link would actually be the same for every entry except the last bit would be their username, since that's how Twitter works, so is there some formula I can enter to this column so when I enter the username it automatically makes that text a link to twitter.com/ whatever I typed in?

 

Here is how it looks, I've blurred sensitive info.

 

 

I am also making the Discord username a link but no formula would work with that since the link is a random hash Discord generates for each person. Twitter uses the same predicable url for every user so I can at least automate that much if someone here knows how the formula would work.

 

Thanks!

[SansVarnic]

@Invincible Sugar it's not a formula you're looking for its a function, since I am not a google sheets user, I can tell you exactly how to accomplish this but in Excel or Access it's going to be a validation or relationship you're trying to create. I am sure there is a google variation of this.

 

I am sorry I'm not helping much.

[Invincible Sugar]

36 minutes ago, SansVarnic said:

@Invincible Sugar it's not a formula you're looking for its a function, since I am not a google sheets user, I can tell you exactly how to accomplish this but in Excel or Access it's going to be a validation or relationship you're trying to create. I am sure there is a google variation of this.

 

I am sorry I'm not helping much.

Hmm, actually that might be all I need. Now that I know more specifically what it's called I can research it more on my own. Thanks for the info!

[AngryPig]

10 minutes ago, Invincible Sugar said:

Hmm, actually that might be all I need. Now that I know more specifically what it's called I can research it more on my own. Thanks for the info!

If you want it all in one column AFAIK you would need to use Google Apps Script

 

If you are happy to have two columns, you can use concatenate()

 

Twitter Handle | Twitter Link

JoeBlog | concatenate("twitter.com/", A1)

 

Something like that

 

Edit: this may not be a clickable solution like you wanted sorry

 

Edit 2: Should be clickable now;
 =HYPERLINK(CONCATENATE("http://www.twitter.com/", A3), CONCATENATE("@", A3))

Where A3 is a reference to your previous column