I want to take a field on my sheet and compare it to the total submissions on another sheet to get a percentage.
Ex. I want to take the total for cell/number of total submissions (rolling) on another sheet so that it updates automatically each time someone submits the form.
How would I do that formula?
Help Article Resources
Check out the Formula Handbook template!