Cross Sheet Reference a URL Link

Mike TV
Mike TV ✭✭✭✭✭✭

I've got a database sheet listing a bunch of fertilizers and how much to feed of each fertilizer at various stages of growth. During certain stages of growth some fertilizers aren't used so I'm using this sheet to feed reports which builds an easy to read list of what to feed so that any fertilizers not used aren't shown due to the filter I set up on the report. I've published each report so that I could obtain a URL to the report.

On the database sheet, row 1 is a CTRL-K hyperlink to the report for that particular growth cycle. From the Master sheet which tells a cultivator what to feed, I'm trying to create a formula which links to the report when that report's growth cycle is listed on the Master sheet. It works and displays the text of the proper fertilizer list.

Here's the problem I need help with...what comes through on the Master Sheet is only text. The hyperlink doesn't come through so you can't get to the report to see what ferts should be used.

It looks like it's just not possible for cross-sheet references to maintain URLs. Does anyone know of a workaround?

@Genevieve P.

@Paul Newcome

Best Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    Combination of TinyURLs and renaming of a column to a shorter column name gave me the space I needed to make this work but it looks ugly and would look much better if cross-sheet references would maintain URL links from other sheets. It's extremely absurd that they don't already do that and only transmit the text.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    I agree that being able to maintain the link with the custom text would be ideal.


    In the meantime though, you could set up a reference table with the URLs in one column and an identifier in another column then use an INDEX/MATCH to pull the appropriate URL in. Granted it still has the URL display instead of the custom text display, but at least you don't have to fight with an ugly nested IF.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!