Best Of

#1. We have already upgraded and are impacted by the lack of compatibility with the Jira Connector and Jira v10. Considering that the Smartsheet Jira Connector is a paid premium offering, I believe it should be maintained as often as there are releases with the tools you offer integrations. Jira v10 was released on August 22nd, 2024. We have several workflows broken, including one utilized to facilitate a weekly meeting with our CIO.

Thank you Genevieve, this method works great, I use it regularly. For clarity for others here is my method:

1) Load the sheet/report or dynamic view you want the user access in your browser.

2) Copy the full URL from your browser address bar.

3) Create a helper column in your sheet called "Sheet Link" or something similar. Format as a text field.

4) Paste the full URL into the cell. Add =" at the front and " at the end. It would look like this: ="pastethefullURLhere"

5) Then convert the cell to a "column formula" (right click on the cell containing the URL formula and select "Convert to Column Formula"

6) Then include the "Sheet Link" field in your report or dynamic view.

This should result in a clickable link. One added benefit of this approach is that the link will open in a new browser tab for the user making it easy to navigate back to the source report by just closing the browser tab.

Hope this helps.

-Mons

Hi,

I am attempting to create a Dynamic View that is built off of a report to show current user tasks. In the report, I included the "Sheet Name" column so that you are able to click on the Sheet Name link and it will take you to the specific row in that sheet. When adding the "Sheet Name" column into Dynamic View, the link no longer appears and the column simply states the name of the sheet.

Is there a way to include this "Sheet Name" link in the Dynamic View so the user is still able to click on the hyperlink and go directly to the specific row in the sheet?

Thanks!

Hi,

I hope you're well and safe!

Here's where you can select or change it.

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!