Skip to main content

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

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/')
)



Reply


Terms & Conditions