クラシックファイルタイプは2021年1月をもって使用できなくなりました。クラシックファイルを移行することも、PDFをダウンロードすることもできます。詳細はこちら

Using Formulas vs. Links

回答済み
デモをリクエスト

When you have a link, you have the option of clicking the paper clip to direct you back to the source.  

For a formula, is there a shortcut to accomplish this?  In Excel, if you hit "Control + [ " it brings you back to the source of the formula.  Does this shortcut exist, or do I need to read the formula and figure out for myself how to navigate to the source?

Thanks! 

0

コメント

5件のコメント

日付 投票
  • 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

サインインしてコメントを残してください。