There are times when sharing a doc, or just for your own simple use, it’s helpful to have a canvas control to quickly sort a table. The table controls for sorting don’t have a formula builder, so another strategy is required to make this a possibility.
Here are two examples, one that lets you choose the column to sort by and the other that lets you choose the column and direction.
The strategy here is to create a column that really just copies the column data for whatever column is chosen in the control. Then setting this column as the one to sort by for the table.
The second example takes this a step further and creates a sort number based on the rows position after being sorted by ascending or descending.