Calculating an average from column data

Buster Davis

Buster Davis ✭✭✭

02/12/24 in Formulas and Functions

good afternoon, so I have the following sheet setup. I would like to do a calculation for the overall status that would show the average percentage from the the other columns.

Also, what format would I used to show 100% in a cell? I tried percentage but when in 100% it does not show that.

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Next Expense Date Formula
I need to create a formula that will find the next expense date based off 3 other column categories. The columns and their categories are as follows: Due Date (single date when expense is due), Program ( Men, Women), and Budget Impact (Income, Expense). For this formula I need to find and return the next expense date from…
Automation Question around running on a Date field
I'm working on doing some cleanup on a smartsheet that had some extra columns/automation that I don't believe are in use. I have a question around how an automation uses dates, so i'll give what is probably unneccesary background. :-) For example, in our smartsheet there is a date field called CST Due for Info Update -…
Row with Multiple drop down choices and creating a summary
We have a Column on our Sheet which is a drop down list however more than one can be picked? Is there a way to as a summary to look for that field so that it sums it up? Below are 2 which are in a row and chosen from the drop down When we do the summary we would like this to be counted in both the IT Operations and Infra…