Here’s an example of multiplying by a scalar. In this example I multiply column A by 5.
| A | B |
| --- | --- |
| 2 | 10 |
<!-- TBLFM: $2=($1*5) -->
You will need to evaluate the formula (using the button in the toolbar) then sort the table afterwards using the button in the toolbar. Sorting is a manual button click, and not available from within a formula.
More information can be found in this document.