Auto-calculate rooms needed for an event in Google Sheets

Auto-calculate rooms needed for an event in Google Sheets

Channel:
United States Google Workspace
Subscribers:
1,010,000
Published on ● Video Link: https://www.youtube.com/watch?v=H_roGo6iXSY


Category:
Tutorial
Duration: 4:00
17,520 views
204

Holding an event, and need to calculate what room size you need for registered attendees? In this video, we show you how to create a formula - using an IF statement in Javascript - to calculate the exact room size you need for your events. Watch to learn how you can utilize Google Sheets for this project!

Previous Episode →https://goo.gle/3aMHkhq

Copy sheet → https://goo.gle/3hp5Oji
Instructions here → https://goo.gle/2Qcmcay
Google Apps Script → https://goo.gle/3cMWwLz
Beginner tutorial for Google Apps Script → https://goo.gle/2zOtDA6
400+ built-in Sheets functions → https://goo.gle/2XTZcS9
Custom function → https://goo.gle/2ZhM6j6

Sheets to Apps playlist → https://goo.gle/SheetstoApps
Customizing G Suite playlist → https://goo.gle/2Rp30br

Subscribe to G Suite → https://goo.gle/GSuite

Product: Google Sheets, Apps Script; fullname: AGV;

#SheetsToApps #CustomizingGoogleWorkspace



Other Videos By Google Workspace


2020-09-15Supercharge productivity with no-code apps using AppSheet
2020-09-15G Suite for developers: Build, extend, and grow your business with the G Suite developer platform
2020-09-15Introducing Google Meet hardware - Series One
2020-09-15Enabling a remote workforce with Chrome Enterprise
2020-09-15Equip your frontline workers for success with Android
2020-09-15G Suite accessibility features to empower inclusion
2020-09-10How to send text messages using Google Sheets and Twilio
2020-09-08How to view revision history in Google Docs
2020-09-01Teamwork from anywhere: G Suite's vision for content collaboration
2020-08-31Ver la disponibilidad de otra persona en Google Calendar
2020-08-27Auto-calculate rooms needed for an event in Google Sheets
2020-08-26Cómo compartir tu calendario de Google personal con el laboral
2020-08-25Creating a quiz in Google Forms
2020-08-24Share your personal Google calendar with your work calendar privately
2020-08-24Cómo hacer un evento privado en Google Calendar
2020-08-19Cómo sugerir cambiar la hora de reunión en Google Calendar
2020-08-19Make a Google Calendar event private
2020-08-18Comparte información dinámicamente en tableros y hojas de cálculo
2020-08-18Presenting data with Google Sheets or Data Studio
2020-08-17Suggest an alternate meeting time in Google Calendar
2020-08-17Cómo crear un calendario para proyectos en Google


Tags:
GDS: Yes
how to calculate rooms needed for an event in Google Sheets
calculate rooms needed for an event in Google Sheets
how to auto-calculate rooms needed for an event in Google Sheets
auto-calculate rooms needed for an event in Google Sheets
how to use Google Sheets
calculate rooms for event Google Sheets
Google Sheets How To
event calculations Google Sheets
Javascript
what is an IF statement
IF statement Javascript
Google Sheets
Apps Script
Sheets to Apps
AGV