This is really helpful, thank you! If you envelope the filter formula inside an IFERROR function you can leave a custom place holder message: IFERROR(FILTER(.....),"Session full") This will swap out the error code #N/A with whatever text you put in the quote marks
**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*"))
This is really helpful, thank you!
If you envelope the filter formula inside an IFERROR function you can leave a custom place holder message:
IFERROR(FILTER(.....),"Session full")
This will swap out the error code #N/A with whatever text you put in the quote marks
**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*"))
Great video, Thanks.
Thank you. This is exactly what I needed.
Thanks!