I run a small campground and want to handle reservations end-to-end inside a single Google Sheet. The workbook should let staff enter or import: • Camper’s name and contact details • Arrival and departure dates • Number of campers in the group Also be able to have the amount of sites/cabins we have From those entries, the sheet must automatically calculate the total price using two factors only—length of stay and group size. I’d like the formulas to sit in hidden or protected columns so nobody overwrites them by accident. A simple, staff-friendly check-in workflow is essential. One click on a “Check-In” button (an Apps Script-powered button is fine) should timestamp the row, mark the camper as on-site, and move the booking to a “Current Guests” tab or highlight it clearly. Core expectations • Clean layout with data-validation drop-downs and clear headings • Lock or protect critical formulas, leave input cells open • Price table or variables I can edit later if our rates change • Apps Script code documented in-line so I can tweak it myself • No third-party add-ons—everything must run natively in Google Workspace Nice-to-have (if it fits comfortably) • Basic dashboard showing today’s arrivals and departures • Alert if a new booking clashes with an existing one Deliver the finished Google Sheet plus any Apps Script files and setup instructions so I can duplicate the template for future seasons.