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

standardized x-axis range on a line graph
When using a side-by-side comparison of data with the same benchmarks, but different data points, is there a way to standardize the x-axis range so that the benchmark line in the two graphs are aligned?
Contact support chat feature
We have an enterprise account and only just noticed this a week ago. Does anyone know when this feature was implemented and is it a live chat session or chatbot driven? Thanks
VLookup help
HI. I need to look up a # based on the entry entered in one column. I have established a look up table, but having a difficult time with the formula. example - I enter ACME Supplies and I want it to look up the vendor number in the table and return the value into the corresponding field.