Kaw Sheetgo is a good place for a spreadsheet-based workflow! Potentially, you could be using Sheetgo to centralise sales tracked in several spreadsheets in one consolidated dashboard.
We even have a template that may fit your needs: https://blog.sheetgo.com/sales-templates/sales-lead-tracker-template/
This template can be customised to accomplish (2) if you are familiar with Google Sheets formulas.
If not, let me know here and I am happy to help!