Cross Sheet Reference a URL Link
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?
Help Article Resources
Check out the Formula Handbook template!