Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URL

Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URL

As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row.

----------------------

Use Case:

  • I leave a comment on Row 1. Row 1 is named "Product Plan".
  • Within the comment on Row 1, I'd like to quickly refer to row 72 (Task Name="Onboarding Process") and utilize a URL that would directly send anyone who clicks on it to to row 72.
  • Ideally, I'd like to be able to just type in the title of the row (Task Name); i.e. "#Onboarding Process" and the comment section would have a drop-down to allow me to choose the row I want to link to (similar to when a user types "@" and a list of users appears).

Example comment: "All onboarding information can be found under #Onboarding Process."

----------------------

Referring to other items is utilized heavily in competing products like Jira and Trello. Referring to another row could be as simple as utilizing a command like "#row72" or "/row 72". Or click the hyperlink button and link it that way.

This would enable users to easily jump from cell to cell and be able to navigate related cells much more quickly. It could even be utilized sheet-to-sheet. Is this an option, or is there a way to do this? If not, are there plans to add this feature?

🧔Brett Wyrick

💻 IT Technical Project Manager, Prosum (Microsoft Consulting Group)

Answers

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

    Hi Brett,

    Great ideas! That would be a great addition to Smartsheet features.

    Please submit an Enhancement Request when you have a moment

    As a possible workaround, you can copy the row URL and paste that in the comment.

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    I know it is not an ideal solution, but you can use the feature (and teach others how) to jump to a specific row within a sheet. I don't know what it is for Macs, but Windows computers uses CTRL+G. Type in your row number, and it will take you there.


    I agree that being able to "tag" a row in a comment would be great, but in the meantime, maybe CTRL+G can help a little.

  • Andrée, Paul -

    Thanks for the responses. I sent in an Enhancement Request for this - I am a bit baffled as to how this isn't already a feature. How do I track Enhancement Requests? I wish that Smartsheet had a "uservoice" sort of forum like Microsoft has for tracking user requests (and would allow users to vote on helpful new features).

    Andree: Copying the row URL I'm wanting to reference, then pasting it in the comments is cumbersome, but for anyone reading, this is how you do it:

    Go to your row, go to the "Row Menu" using the drop-down arrow on the left


    Click "Properties" on the drop down menu.

    Find your Row ID link and copy (CTRL+C).

    Find the row you'd like to put the reference in, open the "Conversation" pane. Paste in the link you copied (will open in new tab):

    The referenced link opens in a new tab, which is not very conducive for working and referencing cells easily. But, it gets it on there. Alternatively, you could go to the paperclip icon, add a URL link, and add it as a comment - but that requires a lot more effort.

    In other project management tools like Jira, I have been able to simply reference the item's name or ticket# (i.e. "SEC-01234) as text and Jira would automagically link it for me.

    Using the "CTRL+G" trick works only when you know that the Row# you're wanting to get to isn't ever going to change - for many of our projects, the row numbers change because we add tasks mid-flight (I imagine almost all agile teams are going to do this).

    Smartsheet, please add cell reference in conversations as a feature!!

    🧔Brett Wyrick

    💻 IT Technical Project Manager, Prosum (Microsoft Consulting Group)

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

    @Brett Wyrick

    Happy to help!

    Yes, a way to search as in a relational database would be magical.

    Regarding the enhancement requests: A few years ago, Smartsheet removed the public roadmap, so, unfortunately, it's not possible to track them, but I know Smartsheet is looking at maybe change it some way in the future.

    Regarding copying the row: Yes, it's a lot of clicks, but it works.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.