Hi all, I have an app based on an Excel spreadsheet that is hosted on OneDrive. The app is running smoothly and automates very efficiently, but I have a minor issue.
I have a column on my spreadsheet entitled 'Trial-sign-up'. 4 out of my 72 listings feature a 'Trial-sign-up' URL, the other 68 entries don't, so we didn't want the 'Trial-sign-up' heading showing up on most results, and thanks to another forum user I fixed this issue with the following code -
This did the trick nicely, but another unexpected issue has arisen - the 'Trial-sign-up' links are no longer live. They display in standard black text that doesn't click through. All other links are live, and 'Trial-sign-up' has a 'DisplayMode.Edit' value, as do all my other links, which are working. Any ideas how I can get my links to work again? Thanks