Hiding form drop downs based on prior submissions

Robyne Hart

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

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"