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

IF statement based on cells in same row
I have a sheet where every row requires two approvals before it's fully approved. What would the formula be to make this work? For example, approval column 1 is named "initial approval" and approval column 2 is named "COHS approval". Both cells are dropdowns with the options pending, approved, or denied. I want the first…
Need to add an or condition to Count/Collect Formula in Project Metrics Sheet.
I need to modify below formula to collect Project ID's on intake sheet where Project Status is "In Progress" or "Not Started". Below works only if Project Status is "In Progress" =COUNT(DISTINCT(COLLECT({Project ID}, {Project Status}, "In Progress", {Project Length}, Label@row)))
Fairly new to Smartsheets - Having trouble with a countifs / date formula. Need your help!
I have a "master data" sheet that has a "DATE OF INCIDENT" field column, and a "FOUND ON A SCHEDULED INSPECTION" field column that populated as either yes or no. These are the two references I'll want to use in my formula on my metrics sheet. In my metrics sheet I want to use a COUNTIFS statement to tell me how many passed…