Enter hyperlink to cell, if another cell is not blank

Melitta

Hello,

Is it possible to enter a hyperlink to a cell using a formula?

I'm looking to have a column check if a cell is blank, enter "No info" if it is blank and if it isn't - enter the hyper link.

=IF(ISBLANK([Provider A]@row, "No info", "<a href="https://weather.com/">Weather</a>")

Thank you,

Melitta

Andrée Starå

Hi @Melitta

I hope you're well and safe!

Try something like this.

=IF([Provider A]@row = "", "No info", "https://weather.com")

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Melitta

I hope you're well and safe!

Try something like this.

=IF([Provider A]@row = "", "No info", "https://weather.com")

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Melitta

Hello @Andrée Starå ,

I always appreciate your help.

Yes, that works. Would you be able to help with a second part? How do I get it to show text other than the URL?

Display "Link for the Weather" rather than https://weather.com?

Melitta

Andrée Starå

@Melitta

Excellent!

I'm always happy to help!

Unfortunately, it's not possible at the moment to change what is shown except for the formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Melitta

@Andrée Starå ,

I will send in an enhancement request, thanks.

I came across a comment about a replacement tool that would replace the URL, something to this effect <a href='www.weather.com'>Link to Weather</a>.

Have you had experience with a replacement tool to do something like that?

Melitta

Andrée Starå

@Melitta

Excellent!

You're more than welcome!

Unfortunately, no, I haven't used a tool like that.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!