Google Sheets Auto Timestamp with Apps Script | Start & End Time + Custom Menu (Day 30)

Auto add START & END timestamps in Google Sheets using Google Apps Script + Custom Menu (Day 30).

Google Sheets Auto Timestamp with Apps Script | Start & End Time + Custom Menu (Day 30)

Day 30 of Google Apps Script Training (Beginner to Pro) 🎯
In this lesson on MANG TECH, we convert a manual “Turn Around Time (TAT)” tracker into a ONE‑CLICK Apps Script automation.
No formulas. No manual typing. Just one click for accurate TAT tracking.

✅ What you’ll learn:
• Auto add FMS START Timestamp (only when Name/Task is entered AND Start cell is empty)
• Auto add FMS END Timestamp (only when Status becomes “Complete”)
• Protect your data (no overwriting old timestamps)
• Handle case sensitivity (Complete / complete / COMPLETE)
• Create a Custom Menu (Main Tech) to run code from the Sheet UI
• Bonus: const vs let, array indexing (Col A = 0, Col B = 1) + looping row‑by‑row
• Add safety checks (Sheet Not Found) + a simple “About” popup

🧩 Workflow used (TAT Automation Blueprint):
Client Check‑In → Service In Progress → Service Complete ✅

🧠 Core Conditions (Simplified):
START TIME:
If (Name column != "" AND Start Timestamp column == "") → Start Timestamp = new Date()

END TIME:
If (status.toString().toLowerCase() == "complete" AND End Timestamp column == "") → End Timestamp = new Date()

📌 Chapters (update timings after final edit):
00:00 Before vs After (Manual Error vs Automation)
01:10 Custom Menu (onOpen + createMenu)
03:20 Start Timestamp Logic (Row loop + condition)
06:30 End Timestamp Logic (Status = Complete)
09:10 Case‑Insensitive Check (toLowerCase)
10:20 Safety Net (ui.alert + return)
11:10 Final Test + Output

📂 Slides/PPT used in this video: [Paste link here]
▶️ Full Playlist (Beginner to Pro): [Paste playlist link here]
📝 Template Sheet + Full Code: [Paste your link here]

If you face any issue, comment “DAY30” + your error screenshot.

👍 Like • 🔔 Subscribe • 🧠 Share

#GoogleAppsScript #GoogleSheets #Automation #Timestamp #TurnAroundTime #CustomMenu #AppsScriptTutorial #SpreadsheetAutomation #MANGTECH

Welcome to Mang Tech, your ultimate tech companion! I'm Atul Chaudhary, and I bring you daily tech videos covering everything from Excel, Google Sheets, VBA, App Scripts, SQL, Power BI, and the latest AI tools, to tech gadget reviews.

On this channel, you'll find step-by-step tutorials, tips, and tech solutions designed to make your life easier. Whether you're a beginner or a pro, there's something for everyone!

👉 Subscribe to Mang Tech for:

In-depth Excel tutorials (Basic to Advanced)
Google Sheets hacks for productivity
Mastery in SQL queries and coding tools
AI tools explained and compared
Insights into the latest tech gadgets and devices
Stay updated with the latest in tech! Don't forget to like, share, and subscribe for more exciting content.

Whether you're a beginner or a pro, Mang Tech has something for you!

🎥 Don’t miss out—subscribe today for daily tech videos!
🔗 Follow me for updates and behind-the-scenes content:

🔴 YouTube: Mang Tech
🔵 Instagram: mt_mang_tech
🔵 Facebook: Mang Tech

👉 Join the Mang Tech community and navigate the digital world with confidence!

google apps script,google sheets,google sheets timestamp,apps script timestamp,auto timestamp,start timestamp,end timestamp,turn around time,TAT google sheets,FMS timestamp,custom menu apps script,Main Tech menu,onOpen,createMenu,SpreadsheetApp.getUi,run script from menu,status complete,case insensitive,toLowerCase,error handling,ui.alert,google workspace automation,apps script beginner,apps script advanced,day 30 apps script,MANG TECH,google apps script hindi,google sheets hindi,MANGTECH, AI, ai

Видео Google Sheets Auto Timestamp with Apps Script | Start & End Time + Custom Menu (Day 30) канала Mang Tech