I want to create a cell that will report the # of Status "Complete" If the value in an other column



I would like to create a summary sheet ((29) GS Bugs/Enhancement summary - Smartsheet.com) .

I want to display the quantity of "Complete" from the value Enhancement.

Same with "Not Complete" from the value Enhancement

And then the % of Complete from the value Enhancement

and then for each row.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!