Reference Another Sheet without Function
We use "Reference Another Sheet" quite a bit in our sheets. We do this by starting a function in a cell, then putting an open parenthesis, then clicking on the link in the resulting dialog box that reads "Reference Another Sheet" . This works fine.
The thing I'm running into is sometimes I want to reference another sheet *without* using a formula  i.e. I want the cell of one sheet to carry over to the cell of another sheet without any function applied or editing of the data. (There are many of our situations where this makes more sense thank Cell Linking.)
I have found that I can't "get to" that link called "Reference Another Sheet" unless I first use a function (and left parenthesis). So what I end up doing is temporarily using a function:
=SUM({create other sheet reference...})
then I delete the SUM, ( and ). This works but is a bit tedious.
Is there a way to do Reference Another Sheet in a cell without using a function first?
Comments

Hello,
The only other way to create a cell reference to another sheet would be through cell linking. When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.

Thanks for the comment  it helps to know that I'm not just "missing" something.

I am very curious...
Could you provide some use cases where a standalone cross sheet reference (without a supporting function) would work differently/better than a basic cell link?
I use quite a bit of cell linking and am wondering if maybe there is a way I can make my mess a little more efficient.

I have a use case for this...
I need to calculate offer acceptance rates for our TA team. I have one sheet that calculates Total Hires for each recruiter, and another sheet that calculates Total Offers (hires + offer declines) for each recruiter. On my Offer Acceptance Rate sheet I want to divide Total Hires/Total Offers for each recruiter to get the acceptance rate. I've tried starting with =sum( and referencing each sheet, then deleting the SUM function but I'm getting invalid operation errors.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 382 Global Discussions
 212 Industry Talk
 444 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 291 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!