Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formulas

Cassandra Mantellini

Cassandra Mantellini ✭

06/24/16 edited 12/09/19 in Archived 2016 Posts

Thanks for the help!

Screen shot 1.PNG

Screen shot 1.PNG

Screen shot 2.PNG

Tags:

Formulas

0 ·

Comments

Peter Kirkham ✭

06/27/16

Trick is to get the formula to ignore the n/a. Essentially your grade is number of '1's divided by the number of numerical values.

=SUMIF([Properly Documented]1:Properly1, 1) / COUNTIF([Properly Documented]1:Properly1, ">=" + 0)

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Need a better Sheet Summary Formula - (Collect/Max & Index/Match)
In my example, I am able to return the top Sales for an item based on certain criteria for a Sheet Summary formula (Shirt Top Sales) with =MAX(COLLECT(Sales:Sales, Product:Product, "Shirt")). I am also able to return the Color for the Top selling Shirt (Blue) with a formula using the previous summary value in the formula:…
Cross sheet reference - count with multiple parameters
Hello all, I'm looking for advice to write a cross-sheet reference formula. I have two sheets: one list of all students who have completed internships, and a second sheet with a list of organizations where our students have interned. I'd like to pull in a count of how many students interned at a particular site in a…
Is it possible to add child rows to multiple parent rows with a single API call?
I am attempting automate adding standard sub/child tasks to many parent tasks at the same time. Following the API documentation Specify-Row-Location I am using the parentID + toBottom location attributes for every child row. I am consistently getting errorCode 1123 when the program moves from the first parent row to the…