Use Shortcuts to avoid fat finger issues and speed up data entry for numeric and date columns.
Numeric columns perform an operation. e.g. with a shortcut of 'M' which multiplies by a million, then typing 3M will emit 3,000,000. For dates the current value is replaced with a new date value.
In this example we created 2 Shortcuts:
- a numeric Shortcut where 'K' multiplies numeric cells by 1,000
- a Date Shortcut where 'N' uses the System Filter of 'Next Working Day' to replace the cell contents appropriately.