Help

Create links

Topic Labels: Formulas
178 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tiago_Relva
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello.

I have a cell that we input text and then in another cell that text in converted to an url

IF({LINK}=BLANK(),"","https://example.com/"&{LINK})

Ex:

CN-349302 -------->  https://example.com/CN-349302 

 

But what kind of formula can I create to convert the text to an url if we put more than one "string" ?

Ex:
CN-234398, CN-23454
I'd like to convert this to https://example.com/CN-234398, https://example.com/CN-23454   

The result can be divided by a comma or another symbol 

any help would be appreciated

1 Reply 1

Hi,
don't use BLANK() - it can produce wrong result.
To check 'nonemptiness', just use IF({Field}, ...
Also 'value_if_false' can  be omitted in IF, default is empty string.
So, just type  IF({LINK}, *your formula* ). Brackets can be omitted for one-word field names 

IF(LINK,
  SUBSTITUTE(', '&LINK,  ', ',  ', https://example.com/')
)