Smartsheet (Windows) keyboard shortcuts ‒ DefKey

0	Ctrl + S	Saves all unsaved information
-1	F2	Enters edit mode on selected cell
0	Ctrl + Z	Undo the previous action since the last saved version
0	Ctrl + Y	Redo the previous action since the last saved version
0	Ctrl + D	Fill down
0	Ctrl + F1	Enter full screen
0	Ctrl + F1	Exit full screen
0	Ctrl + X	Cut
0	Ctrl + C	Copy
0	Ctrl + V	Paste
0	⤶ Enter	Open the Edit Widget dialog for the selected dashboard widget (when dashboard is in Edit mode)
0	Ctrl + F	Find information within a sheet
0	Ctrl + G	Display the Go To Row dialog to navigate to a specific row in the sheet
0	Home	Go to the first cell of the current row
0	End	Move to the last cell of the current row
0	Page Up	Moves you up in a sheet
0	Page Down	Moves you down in a sheet
0	Ctrl + B	Bold
0	Insert	Inserts a row above the selected row
0	Space	Display or remove a checkbox, star, or flag in the selected cell
0	Ctrl + E	Open the Edit Row dialog
0	T	Inserts today's date
0	← ↑ → ← ↓ →	Select card
0	Space	Expand or collapse card
0	⤶ Enter	Open the Edit Row dialog
0	↑ Shift + ⤶ Enter	Add a card (enter a title and press Enter again to add the card)
0	Ctrl + U	Underline
0	↑ Shift + Space	Selects the entire row of your active or selected cells
0	Ctrl + Space	Selects the entire column of your active or selected cells
0	Ctrl + ⤶ Enter	Inserts a carriage return or line break in Text/Number cells
0	Ctrl + Home	Takes you to the top left cell of a sheet
0	Ctrl + End	Takes you to the bottom right cell of a sheet
-1	Ctrl + ↑ Shift + F	Open the Search dialog for advanced search options
0	Ctrl + K	Open the Hyperlink dialog for selected cell
0	Ctrl + F6	Move focus forward to the next accessible region
0	Ctrl + ↑ Shift + F6	Move focus backward to the previous accessible region
0	Ctrl + ↑ Shift + ↑	Highlight all rows/cells above the row/cell you selected
0	Ctrl + ↑ Shift + ↓	Highlight all rows/cells below the row/cell you selected
0	Ctrl + /	Open a Sheet
0	Ctrl + I	Italic
0	Ctrl + L	With the insertion point positioned on the column name in the formula, creates an absolute reference (cell reference lock)
0	Alt + F	Open the File menu
0	Ctrl + ]	Indent the row (you will see the indent level in the Primary Column only)
0	Ctrl + [	Outdent the row (you will see the indent level in the Primary Column only)
0	Ctrl + L then L	Inserts $ after column name (vertical cell reference lock)
0	- then Number	Enters a date n days before today’s date
0	+ then Number	Enters a date n days from today’s date
0	Ctrl + L then L then L	Inserts $ around column name (full cell reference lock)
0	Alt + 0 then 1 then 4 then 9	Inserts a bullet point in the cell

NOTE: To insert multiple rows at once, press Shift and select multiple row headers, then select Insert.
For example, if today’s date is 12/11/17, pressing +3 will enter 12/14/17.

The following shortcuts work in cells of the Date column type.
Note that these abbreviations currently work only for English terms.
For example, if today’s date is 12/11/17, pressing -3 will enter 12/8/17.
Type sun, mon, tue, wed, thurs, fri or sat: The date corresponding to the day of the week in the current week
For example, if today’s date is 12/11/17, typing “sun” will return 12/10/17.
Type yes: Yesterday's date
Type tom: Tomorrow's date
Type last week: The current date -7 days
Type next week: The current date +7 days
mmm dd, where mmm is a series of letters representing a month and dd is a series of numbers representing a day: The date of the entered string. For example, typing Dec 17 in the year 2019 will return 12/17/19.

=COUNT([Order Number]$4:[Order Number]6)
Inserts $ before the column name (horizontal cell reference lock)
=COUNT($[Order Number]4:[Order Number]6)

NOTE: In order to see the carriage returns in the sheet, apply wrap formatting to the cell by clicking the Wrap Text button on the toolbar at the top of the Smartsheet window.

TIP: If you've copied a multi-line cell in Excel or other program, double-click on the cell in Smartsheet before pasting it in to prevent the lines from spilling over into the cells below.
You can copy data within a sheet in Smartsheet or between sheets. You can copy rows, cells, formulas, hyperlinks, and hierarchy.
NOTE: Copying a row does not copy its associated attachments or comments.
Select the cells that you want to fill. The cell containing the value that that you want to fill must be at the top of the selection.
TIPS
This shortcut is useful when a column contains a formula that you want to use in every cell in that column.
Another way to use this feature by selecting and dragging the cell from its lower-right corner.
=COUNT($[Order Number]$4:[Order Number]6)

Source: Smartsheet help page

Please temporarily enable JavaScript in your browser to post text. This is to avoid comment bots. We're sorry for inconvenience. #commentForm { display: none; }