Index/Collect

06/10/21
Answered - Pending Review

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:



Answers

  • Bassam KhalilBassam 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: [email protected]

    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful". 

Sign In or Register to comment.