How to get an average of % Complete.


Im working on a spreadsheet that has tasks for a job status report of whether it is complete, not started or in progress. This feeds into another column called % complete which I used the IF function to turn the status into a percent. How can I get an average of the percentages?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!