Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Creating multiple destination links within a single spreadsheet cell

5

Opmerkingen

19 opmerkingen

  • Evanjelin Karunya Savio

    Hi Mike!

    The above process works in an embedded table cell within word document but not in a spreadsheet cell. When i try to paste multiple destination links within a spreadsheet cell, after double clicking on the cell, data is pasting as a normal text and link option doesn't show up while pasting. Let me know if there is a way to achieve in a spreadsheet cell.

    2
  • Mike

    Hello again, Evanjelin!

    Yes, in next gen does support multiple links inside a cell, sometimes called sub-cell linking. For example, if you had a line item that listed a numeric value within it, you can link that item as well as the cell itself. Here's a Help article about the process: https://support.workiva.com/hc/en-us/articles/360035640332-Creating-Multiple-Links-Inside-a-Cell.

    Hopefully this helps. Let me know if I can help answer any other questions you have, or you need any assistance on the above. Thanks again and have a super day!

    1
  • Roman Magar

    That's true. This capability is only available in the table in the document but not in the spreadsheet itself. Is this something coming to the spreadsheet itself? 

    0
  • Evanjelin Karunya Savio

    Yes, but a different spreadsheet. Source and destination both are spreadsheets but are in different folders. Is there any way to achieve this using cross sheet formula? I tried to use this but it was not recognizing the destination sheet within formula field. 

    0
  • Mike

    You are both correct, sub-cell linking is currently only available in embedded tables, but not the Spreadsheet itself. Roman Magar we do plan to add this to Spreadsheets but I don't have a timeline for when this would be available. I've added you both to the request, however, and we'll keep you updated.

    The most common workaround we've seen, as you mention, is some sort of concatenate or simple reference formula. You can reference across sheets of the same Spreadsheet, but not across separate Spreadsheets. Is your formula going across sheets housed in the same file, or separate files Evanjelin Karunya Savio?

     

    0
  • Adam Horowitz

    Hi Mike - is there an update as to a potential release date for subcell linking within a cell of a spreadsheet?

    0
  • Mike

    Hi Adam Horowitz! I double checked and at this time there's not been much change on our end regarding this enhancement and it remains solely proposed at this point. I'm happy to connect you to that request as well so you can stay apprised. Sorry I couldn't provide any better news. Holler if you need anything further. Cheers and happy Friday!

    0
  • Alecia Valek

    Hi Mike - I am very interested in being updated on this enhancement as well, so if you could connect me to the request as well, that would be great! 

    0
  • Mike

    You got it, Alecia!

    0
  • Danielle Smith

    Hi Mike, could you also connect me to the request as our IR team would love this feature! Thanks :)

    0
  • Mike

    It's a deal, Dani!

    0
  • Dallas Thornton

    Same, I'm finding more and more often that I'm wishing Spreadsheets had this feature. 

    0
  • Mike

    Quick update here. The enhancement for supporting sub-cell links in Spreadsheets has been moved to the future roadmap. I don't have a timeline as of yet, but its good news. Your perseverance has paid off.

    We'll continue to take in new requests and feedback, so keep it coming. Let me know if you have any questions for me in the meantime. Cheers!

    0
  • Angela Kyle

    Hi Mike, I was wondering if this is offered yet. Thank you! 

    0
  • Mike

    This is still on our roadmap, Angela, though no specific timeline as of yet.

    0
  • Stacey Borgstadt

    I''m interested in this functionality as well.

    0
  • jho

    +1. I'm interested in this. Thank you!

    0
  • DJ Moore

    Our team would definitely use this feature if implemented. Thanks

    0
  • Isaac Oard

    Thanks everyone! We have added you to the idea ticket!

    0

U moet u aanmelden om een opmerking te plaatsen.