Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Command + L on Mac - Is it working?
I am working on formalas in Smartsheet using a Mac. From my understanding, clicking Command + L is supposed to convert a relative reference to an absolute reference by automatically inserting the "$" in front of the column and row of a formula, but it does nothing.
However, if I go to my browser and click Command + L all the text in the address bar is selected, which makes me think this is a problem in Smartsheet. I can always manually type in the "$" into my formula, but it is a matter of convenience.
Any ideas? Any feedback will be greatly appreciated.
Comments
-
I did not know that trick.
Don't use a Mac, so can't help you, but you helped me!
Craig
-
Ha! Well, you have to click Control (Mac=Command) + L twice. The first puts the "$" in front of the column name and the second puts the "$" in front of the row number, or at least that's how it's supposed to work. It's not working for me....
-
I was about to post that it wasn't working under Windows for Chrome or Firefox either.
And it isn't. Sort of.
If the cursor is at the very end or before the equals sign, it does not work.
=[Week Starting and Date]388
^ here or ^ here
but anywhere else it does.
I consider that a bug. If I have the cursor at the end, but I'm still inside the cell, then I am editing.
"While editing, you can press Ctrl+L to lock the column name or row number (inserting the $ symbol in front of the column name or row number) allowing formulas to be copied yet retain their reference to the desired column or row."
I am editing.
Try that.
Craig
-
Alright. I tried placing the cursor anywhere else but the very end or before equals sign and you are right, the shortcut works.
How you figured that out, I'll never know. I'm impressed.
Don't you think they oughta fix this bug?
-
Tiffany,
I'm just that good.
More serious short version, I can think like a programmer if I need to.
(I sense a long rant coming, so I'll stop)
Yes, I think that is a bug and I think they should fix it.
PROBABLY should be fixable in a short time, but I've seen some bugs that looked like they were but required a complete overhaul of the design, so I avoid estimating a programmers work for them. Or demeaning them by implying their work is easy.
A master glass blower makes it look easy, but he/she has been doing it for 20+ years.
(That reference is to the developers, not me)
Craig
-
Another reason it is a bug:
Clicking "F2" to edit the cell takes me to the end of the formula - where I can't use Ctrl+L.
Craig -
Thanks Craig for your responses!
On a Mac, the kayboard shortcut is CTRL + L, not COMMAND + L.
Here's a list of keyboard shortcuts: http://help.smartsheet.com/customer/en/portal/articles/522200-keyboard-shortcuts
I checked in Excel (Mac) and using the keyboard shortcut with the cursor at the end of the cell reference WILL work (while your cursor needs to be inside or at the beginning of the cell reference in Smartsheet). I will pass this along to the Dev team working on formulas!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives