You can do this with:
Google Sheets timestamp formula/script
ARRAYFORMULA for auto-fill
Google Apps Script for permanent timestamps
For inventory tracking, I’d recommend using Apps Script because normal formulas recalculate and can break timestamps later.
A simple setup:
Employee...
I am trying to build an Excel sheet to track multiple loans taken from different banks. Each loan has different interest rates, repayment schedules, and maturity dates.
What would be the best way to structure this in Excel so I can easily track repayments, outstanding balances, and upcoming...