Hiding form drop downs based on prior submissions


I'm trying to mimic a Qualtrics survey capability that enables the survey (form) to only show available dates that have not already been selected by prior survey respondents.

Is there a way to accomplish this?


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 05/22/21

    Hi @Robyne Hart 

    Hope you are fine, Unfortunately, you can't change the drop-downs based on prior submissions but you can play around by designing a report filter the available dates, and publish that report as a read-only report for your surveyors.

    in other words, you need to create a booking system. please check my following post that you can use as a reference to design your booking system "Using smartsheet to book workspaces/meeting rooms"

    PMP Certified


    ☑️ 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"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!