# Automated Column Management in Inventory Sheet

> 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.

Section: Google Apps Script

Page: https://showcase.growlyze.cloud/case/gas-automated-column-management-in-inventory-sheet

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.

Image: Syncing active/inactive status between a main sheet and a linked inventory spreadsheet. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image10.png)

Image: A custom menu for updating inventory values and normalizing leading zeros on demand. (https://showcase.growlyze.cloud/case-content/google-apps-script-portfolio/image11.png)