You can use keyboard shortcuts to quickly apply calculations and dates and avoid fat finger or mathematical errors. For example, you can create a shortcut where typing 'M' in a numeric cell will multiply the value of the cell by a million.
To apply a shortcut you simply press the relevant Shortcut Key. For Date-column Shortcuts a new date always replaces the current value. For Number-column Shortcuts a calculation is applied to the new cell based on the cell's current contents and the Shortcut Key (e.g. if you create a 'M' Multiply by a Million shortcut and the cell contains 5 and you then click 'M', the new cell value will become 5,000,000).
You can create your own shortcuts for numeric cells, so that with a single press of a key, a new value is calculated for a cell. The calculation is performed on the cell's existing value and you can set your shortcuts to perform calculations that are relevant to your work.
To create a numeric shortcut:
Click on the New button in the Shortcuts popup and choose to create a Numeric Shortcut.
The Shortcuts wizard appears. Choose to create a Numeric shortcut.
Use the Key dropdown to select the key for the shortcut. You can choose any available letter.
Use the Operation dropdown to select the type of calculation that will occur when you use the shortcut. You can choose from Add, Subtract, Multiply, or Divide.
in the Value field, enter the value that will be used for the calculation. For example, if you enter 5 and you set the Operation to Subtract, using the shortcut key will reduce a cell's value by 5.
You can create your own shortcuts for date cells, so that with a single press of a key, a new date is applied to the cell which replaces the existing date.
To create a date shortcut:
Click on the New button in the Shortcuts popup and choose to create a Date Shortcut.
Use the Key dropdown to choose the key for the shortcut. You can choose any available letter.
Choose between setting a Custom Date Type - that you will apply - or a Dynamic Date Type that is shipped with the system (e.g. Today, Next Working Day etc.)
If the Date Type is Custom enter a date in the date picker. If the Date Type is Dynamic then select an entry from the dropdown.
You can edit, delete and share Shortcuts as you can with all