Averages

Dpence121223
Dpence121223 ✭
in Formulas and Functions

What formula do I use to get an average/percent of flagged to non-flagged cells in the same column?

· Share on FacebookShare on Twitter

Answers

  • Michelle Choate 2
    Michelle Choate 2 Community Champion

    COUNT of flagged cells divided by COUNT of rows.

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate

    · Share on FacebookShare on Twitter

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!