Meeting Room booking using SS Calendar App

Joseph Aloysias
Joseph Aloysias ✭✭✭✭✭
edited 11/15/23 in Formulas and Functions

Hi All,

I'm in the process of setting up a meeting room booking system where I display date/time availability and different status indicators (confirmed, tentative, waitlist).

I'm currently using two sheets: one to collect meeting information via a form and the other to manage meeting slots on the calendar. I've successfully blocked 30-minute slots using a formula that utilizes the INDEX and COLLECT functions to match the date, time, and meeting room.

=IFERROR(IF(INDEX(COLLECT({Meeting Intake - Meeting Room}, {Meeting Intake - Meeting Room}, @cell = [Meeting Room]@row, {Meeting Intake Date}, Date@row, {Meeting Intake Meeting Slot}, [Meeting Slots]@row), 1) = [Meeting Room]@row, "Booked", "Available"), "Available")

Now, I'm looking for a way to block the calendar for longer duration, such as from 8:00 am to 11:00 am. How can I achieve this with my formula? or any other workaround?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!