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 to find all instances of value and return any non-blank cell from another sheet?
Hello Everyone, I'm stumped and need some assistance. What I am trying to do is look for the value in the Cable Number column (Cable Number]@row) on the master sheet in the Cable Number Column on the Update Tracker (Update Tracker Cable}). There will be multiple times this value is in this column but some dates will be…
Wrap Text
How do I wrap text within a cell?
Dollar amounts in a form
I am trying to require a form field to only populate a number to display in a dollar format. I can only see the requirement of a number, but not an actual dollar amount. Is this possible in a form?