Sheet Summary

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!