← Back

Automated Column Management in Inventory Sheet

Google Apps Script
Works with
  • Google Apps Script
  • Google Sheets

Developed an app script to automatically update columns in an inventory sheet based on values in another sheet, enabling seamless data synchronization within Google Sheets.

Syncing active/inactive status between a main sheet and a linked inventory spreadsheet.
A custom menu for updating inventory values and normalizing leading zeros on demand.