Index/Collect

Tabitha W.

I am attempting to devise several sheets for office space reservations.

Right now I have a source sheet driven by a form then a roll-up sheet.

I'm trying to use index/collect to pull in the approved room selections. Right now it is working to pull in the names but I also would like it to pull in the times.

Any creative ideas to get this to work formulas-wise?

Here is what I have so far:

Here is the source sheet:

Bassam Khalil

Hi @Tabitha W

Hope you are fine, i prepared a similar application before for one of my clients, you can check my following post it will help you to understand the technics i used Using smartsheet to book workspaces/meeting rooms. and if you like you can call me to work together to design your application and develop it.

My Email: Bassam.k@mobilproject.it