Select entire sheet then sort on one column (automated)

mikemilstead 

I'm not sure how recorder works, the script could be

function main(workbook: ExcelScript.Workbook) {

	const range = workbook
		.getActiveWorksheet()
		.getUsedRange()

	const sortedColumnIndex = range
		.getRow(0)                // get first row, i.e. headers
		.find("Amount", { completeMatch: true })
		.getColumnIndex()

	range.getSort().apply(          // apply to entire range
		[{
			ascending: true,        // sort order
			key: sortedColumnIndex  // on column to sort
		}],
		false,                     //case insensitive
		true,                      // range with headers
		ExcelScript
			.SortOrientation
			.rows                  // sort by rows
	)
}

We select only range with data, not entire sheet. Find column number for the cell with "Amount". Apply sorting to entire range, not to one column. Use above column as one on which we do sorting.