Enter hyperlink to cell, if another cell is not blank

Melitta
Melitta ✭✭✭✭✭
edited 08/19/22 in Formulas and Functions

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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!