Averages

Dpence121223

Dpence121223 ✭

11/26/24 in Formulas and Functions

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

0 ·

Answers

Michelle Choate 2 ✭✭✭✭✭✭

11/26/24

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!
0 · Share on Facebook Share 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!

Trending in Formulas and Functions

Formula Help
I think this should be a simple formula but I am getting a circular reference error. Can someone help? When the DocuSign status is sent then I would like the status column to change to "Pending Sig. Approval" =IF([DocuSign Status]@row = "Sent", "Pending Sig. Approval", [Status]@row)
Use Contain with And extension?
Hi, I'm trying to pull the correct tuition rate based on MS/M.S. or PhD status and if their department contains Engineering. This is my Active sheet. The formula I'm currently using: =IF(CONTAINS("Engineering", [Grad Field of Instruction]@row), 14750, 10400). So I thought adding the ADD Degree Program = M.S. MS, but unsure…
Formula help please! What formula to mark the parent row "Complete" with an "Not Applicable" task?
In my status column I am using this formula auto update my my parent row: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Not Started") > 0, "In…