Using Formulas vs. Links
AnsweredWhen 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!
-
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
1Perfect thanks!
0And I agree, that if a shortcut existed for that, similar to excel, that would be awesome!
1Nailed 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!
0Nice. 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.1Please sign in to leave a comment.
Comments
5 comments