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

02/08/21
Answered - Pending Review

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?

Answers

  • Bassam KhalilBassam 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)

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Rebecca HillRebecca Hill ✭✭✭✭
    edited 02/10/21

    @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åAndrée Starå ✭✭✭✭✭
    edited 02/10/21

    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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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

  • 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

  • Thanks @Genevieve P. !

Sign In or Register to comment.