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

Using Formulas vs. Links

Answered
0

Comments

5 comments

  • Dan Packer

    Hey Michael,

    It's actually in the same place as the link that you're used to following, but a different tab.

    Here's what you're seeing:

     

    Here's what you will see when you click the "fx" tab in the link section of the right sidebar:

    1. is where link references and the "go to" buttons sit.

    2. is where the cell references for formulas are.

    3. the formula cell references also have "go to" buttons making it super easy to hop around through the spreadsheet.

     

    I do agree however, that having shortcuts would be pretty useful.  If they exist please let me know :)

     

    Dan

     

    1
  • MICHAEL LIEB

    Perfect thanks! 

    0
  • MICHAEL LIEB

    And I agree, that if a shortcut existed for that, similar to excel, that would be awesome! 

    1
  • Mike

    Nailed it Dan Packer!

    You are correct, at this time there's no shortcut available similar to Excel, but our Product Team is definitely looking into it. I've shared both your feedback with the team and will keep you posted with any updates. Thanks for the great convo and holler if you need anything else. Cheers!

    0
  • Dallas Thornton

    Nice. I had just starting writing up a big post about needing this. Glad I found this post before doing so and glad the functionality exists. It's been a pain not using it. 

    However, I did want to follow up on a couple of things. First, any update on the hotkey development for this? 

    Second, for Workiva Links we have a blue triangle in the corner that highlights that a cell is reference as a source. Would be nice if there was a corner/color mark for cells that are directly referenced by another cell. It's slightly more complicated since you can have a cell referenced formula both as a source and still having it's own formula, but maybe could use a different color. If you don't feel another color/triangle on a cell would be good, you could potentially add it as an Overlay and a reviewer could show Overlays and select "cell formula references" to highlight any cells which are sources.   

    1

Please sign in to leave a comment.