Formula to calculate percentage to apply to rest of rows below in "percentage of countries" column

Options

I wanted to calculate the percentages for each country as shown above. But when I got that of the United States, I wanted a formula that would be able to apply to the rest of the countries (in rows) when I hold and move the cursor down. Am getting an error message when I click, hold the cursor and move it down the "percentage of countries" column in order for the percentage to auto calculate. Please what is the formula to help resolve this issue? Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!