Is it possible to create an "If" statement that includes a hyperlink?

I have a column of data which reflects the status of a project. Statuses include "Completed", "On Next Report" etc.

I'd like to embed the report schedule into the cell when the project status is "On Next Report" so viewers can easily click and see when the next report will be published.

In my head, this is something like an "If" statement "=If ([Status]@row = "On Next Report", "URL to publish date") but...that doesn't quite work the way I want it to.

I know I can manually add a hyperlink with "Display text" for each of those cells, but, that feels...tedious. Would love to automate it possible.

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Susan L.

    I hope you're well and safe!

    Please elaborate on what isn't working and how you would like it to work.

    I hope that helps!

    Have a fantastic week & Happy New Year!

    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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Susan L.
    Susan L. ✭✭✭✭

    Hi Andree,

    Thanks for responding!

    I have a text column in a sheet that reflects the status of project proposals as they move through an approval system. The data are updated with a data shuttle, and the "Next Sign Off" column comes in as plain text.

    Because some of the statuses reflect steps outside our unit (think larger, institution-level meetings), I wanted to link to the website that lists those meeting dates.

    I can manually add a hyperlink to selected text using the "hyperlink" option, but, what I would love to do is automate the process. So, when the status "Curriculum Report" appears in the "Next Sign Off" cell, include the URL to the report website, but, keep the words "Curriculum Report"-don't list the raw URL.

    It would look something like this:

    I've manually added the hyperlink here. I'd love to do it with a formula/automation. I think I need to add a column and create an "If" statement, something like "if(Next Sign Off)@row = "Curriculum Report", "hyperlink to report")) but, that doesn't work the way I want it to.

    Any suggestions would be great.

    With thanks,

    Sue

  • KCI
    KCI ✭✭✭

    I am also interested in this!! Thanks

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Susan L. and @KCI

    Currently formulas cannon transfer over hyperlinks, they're only able to surface display text, as you've found. To have the link be clickable you would need to spell out the full URL in the formula, or reference the full URL in another cell to pull through the formula.

    Here's an Idea post in the Product Ideas and Feature Requests area of the Community where you can add your vote and explain your use-case:

    Cheers,

    Genevieve

  • Susan L.
    Susan L. ✭✭✭✭

    Thanks Genevieve-I'll add my comment to the thread!

    Best,

    Sue

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!