Because the Transactions sheet holds multiple accounts, a running total wouldn’t make sense. Also, the Transactions sheet wouldn’t be aware of a ‘starting balance’ for each account, it could only start from 0.
You can use something like my Account Register - Google Sheets to select which account and get a running total. Note that it requires first setting up the Account Reconciliation sheet so it knows the starting balance, and that all the transactions are healthy.