Restricting Form Responses for Each Option in Google Forms

Step 1 : Sample Google Form

Step 2 : Sample Google Sheet

Step 3 : Load up the Formulas

=COUNTIF('Form Responses 1'!D:D,B2:B)
=IF(C2<D2,B2,"This session is full,Please try again later")

Step 4: FormRanger Add-on

Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student. Created a course on Google Classroom

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store