Cursor Bug when Referencing other Sheets in a Formula
Hi,
I found a bug when referencing other sheets in a formula.
When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of them if I don't want to generate an error in my formula.
e.g.
=sum({Range 1}*cursor*)
=sum({Range 1},{Range 2*Cursor*})
The cursor will generate inside the braces range 2 and any following ranges.
Thanks
Best Answer
-
I was able to replicate what you are describing, but only if I haven't put a space after the comma, between the two ranges. This means that when you insert the new reference, the formula has to auto-add in that extra space as well. What I think happens is that this bumps the cursor inside the last brace, instead of keeping it one character over, outside of the brace.
Ex:
Instead of no space after the comma,
=SUM({Range 1},*cursor*)
Try with a space:
=SUM({Range 1}, *cursor*)
This should result in the cursor in the right place, since there are the correct number of preceding characters:
=SUM({Range 1}, {Range 2}*Cursor*)
Try adding in your second range after adding the comma and space to see if that helps!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
I was able to replicate what you are describing, but only if I haven't put a space after the comma, between the two ranges. This means that when you insert the new reference, the formula has to auto-add in that extra space as well. What I think happens is that this bumps the cursor inside the last brace, instead of keeping it one character over, outside of the brace.
Ex:
Instead of no space after the comma,
=SUM({Range 1},*cursor*)
Try with a space:
=SUM({Range 1}, *cursor*)
This should result in the cursor in the right place, since there are the correct number of preceding characters:
=SUM({Range 1}, {Range 2}*Cursor*)
Try adding in your second range after adding the comma and space to see if that helps!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Ok, thanks. Gotta love funky syntax quirks.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!