Smart Life USGoogle Sheets Dock Appointment System · Dashboard
4 posts
Google Sheets booking status automation: create TODAY view — Dashboard part 1
If you're looking for a way to automate your booking status in Google Sheets, this post lays out the approach. When you manage inbound dock appointments in Google Sheets, you constantly run into moments when you want to see only today's trucks in one place. Every time, you have to re-apply the date filter, change the sort by start time, and hide yesterday/tomorrow's bookings…
Create a Google Sheets status dashboard — Dashboard 2
If you’re looking for how to build a Google Sheets dashboard by reservation status, this post summarizes the whole setup. Building a status-based reservation dashboard in Google Sheets ultimately means seeing at a glance how many are Waiting, Arrived, In Progress, and Done right now. In this post, we’ll add an inbound reservation status dashboard in Google Sheets using Apps Script…
Google Sheets Yard Trailer Status Dashboard — Part 3 (Final)
If you’re looking for how to build a Google Sheets yard trailer status dashboard, this post walks through the setup. The inbound appointment system in this series connects reservations, check-in, and yard moves into a single flow. In the previous post - Automate Google Sheets appointment views: build a Today sheet — Dashboard Part 1…
How to Auto-Refresh a Google Sheets Dashboard: Refresh Multiple Views at Once and Automate with Triggers
When you look up how to auto-refresh a Google Sheets dashboard, most guides stop at “make one function per view and attach a button.” As soon as you have three or more views—daily appointments, status overview, yard trailers—you end up with three buttons and three time triggers. The result: multiple time triggers stack on the same function, three functions run in parallel, and they keep hitting the 6‑minute Google Apps Script limit and stopping…