How to conditionally format a row if a hyperlink to another smartsheet is included

Rebecca Hill

I would like to highlight rows that do not include a hyperlink to another smartsheet. I thought it may be best to create logical formula in a hidden column and then conditionally format anything that is showing as false (0) in formula is highlighted. Can anyone let me know which formula can work?

Bassam Khalil

Hi @Rebecca Hill

Hope you are fine, if you add a screenshot ( remove any sensitive data ) for your sheet i can write the exact formula for you, but in general, you can use a formula such as:

=IF(ISBLANK([Column1]1), 0, 1)

Rebecca Hill

@Bassam.M Khalil The cell would not be blank whether it contains hyperlink or not. So I don't think this particular formula would work.

Andrée Starå

Hi @Rebecca Hill

I hope you're well and safe!

To add to Bassam's excellent advice/answer.

Try something like this.

=IF([Smartsheet Link]@row <> ""; 0;1)

Depending on your country/region, you'll need to exchange the comma to a period.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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

Filip

Hello,

I would like to highlight rows where a cell in column A does not include a hyperlink (regardless if to another Smartsheet file or a different URL outside Smartsheet).

Is there a formula that can enable this?

Thanks,

Filip

Genevieve P.

Hi @Filip

There currently isn't a function in Smartsheet that can identify if hyperlinks are housed behind text in a cell. You can create formulas to check if the cell is blank, like the two formulas above, but if there's text in the cell it won't be able to search for a hyperlink behind it. Please let the Product team know of your request and feedback through this form, here!

Cheers,

Genevieve

Filip

Thanks @Genevieve P. !