Limit Google Form Responses with Form Ranger

This tutorial will help you set a capacity on how many times a response can be selected on a question in Google Forms - Which is great when you need to make sure an order or a workshop registration does not go over capacity!

[JohnnyTest-ubll]

This is really helpful, thank you!

If you envelope the filter formula inside an IFERROR function you can leave a custom place holder message:

full")

This will swap out the error code #N/A with whatever text you put in the quote marks

[DeborahLorraine]

**Update** So after testing I found the form was not limiting responses, probably because I edited the formula as shown below. I needed to update the question list in Form Ranger with the new formula and it now appears to work.

So helpful! I'm thrilled to be able to automate our signups. I have a signup form where it's possible to sign up to bring a guest. I modified the Count column to add two columns together:
=(countif('Form Responses 1'!E:E, A2)+countif('Form Responses 1'!F:F, "Bringing*"))

[ewinery]

Thank you. This is exactly what I needed.